Solved

is it possible?

Posted on 2002-07-15
2
145 Views
Last Modified: 2010-05-03
Would it be possible to store a part of the name of a control into a variable and do like:

myVar = "FirstName"

txt & "myVar".text = "blablabla"


instead of doing
txtFirstname = "blablabla"

?!?
0
Comment
Question by:nfuids
2 Comments
 
LVL 10

Accepted Solution

by:
GoodJun earned 50 total points
ID: 7155567
NO.

You can use CallByName to call a method of an object by passing the string representation of the method. But, to
represent a object use the string representation is not possible (or at least not the normal way)
0
 
LVL 2

Expert Comment

by:higijj
ID: 7155569
humm.. ok, well, I guess I'll have to find another way around!

thanks anyway
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
A macro to Count the number of rows across all worksheets 3 95
How to compare ms sql hashbytes results within vb6 5 75
vbModal 12 52
Set email body to html using vbscript 6 41
Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question