LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default Variable Reference to a Form Control

How do I access my form control, when I don't know the direct name of the
object, but only have it placed in a variable.

I have a form with an object named TEXTBOX3

then I have a variable name MYVAR with a value of TEXTBOX3

if I say TEXTBOX3.value I get the correct result

if I say MYVAR.value then I get an error

How do I refer to TEXTBOX3 using MYVAR?

Thanks.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2007 Form Control/ActiveX Control font difference Nikko963 Excel Discussion (Misc queries) 0 April 15th 09 04:21 PM
Tool Tip Text for Form control/ Active-X control Freddie[_2_] Excel Programming 0 October 19th 04 04:14 AM
Is it possible to open the VBA form with a link in a sheet and to pass variable from a cell to the VBA form? Daniel[_14_] Excel Programming 1 August 29th 04 01:20 PM
passing control value from one form to another form mark kubicki Excel Programming 1 April 3rd 04 01:27 AM
using variable for a control name mark kubicki Excel Programming 1 April 3rd 04 12:31 AM


All times are GMT +1. The time now is 11:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"