earlier i was using the default name of textbox and following code was workin perfectly
But i want to refer to use a user defined name DEKHO1
Please Login or Register to view this content.
but the above code is not working ......
what is the correct way to do it???Please Login or Register to view this content.
ActiveSheet.DEKHO1.Text = "Blah"
Elegant Simplicity............. Not Always
first guess would be that the name of the control and the name used in code is not the same.
what do you mean by "user defined name"? if it's a variable remove the quotes
Josie
if at first you don't succeed try doing it the way your wife told you to
The second code works, provided you have named the textbox 'DEKHO1' and the correct sheet is active.
If posting code please use code tags, see here.
Thanks A lot "AndyLitch" got what i needed
hey what would be the syntax if I want to store name of textbox in a variable i.e.
in place of 'DEKHO1' i want to use a variable xyz = "DEKHO1" .
does not work .....what to do???Please Login or Register to view this content.
Last edited by pankajy18; 04-10-2013 at 12:27 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks