Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, I've created a number of textboxes using the following code.
For Count = 1 to 30 Set MyTBox = MyControl.Controls.Add("Forms.textbox.1") With MyTBox .Width = 150 .Height = 20 .Top = 20 * Count - 13 .Left = 2 .name = "TBox" & Count .Visible = True End With Next I now want to access say the fifth box (TBox5) I have a string (BoxName) with the name of the box TBox5 or I could use an integer variable to indicate that I want the fifth box, but how do I refer to this box? I tried: MyTBox.BoxName.value = ... but this does not work, and I tried: MyTBox(5).value = ... this too does not work. What am I missing? Again, thanks for your help in advance!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
Issue when accessing the property/method of a Calender control | Excel Programming | |||
accessing excel combo box control data from vb .net | Excel Programming | |||
Problem accessing control in another form | Excel Programming | |||
Accessing ActiveX Controls using VBA - can't use Control.Name to access. | Excel Programming |