Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox labels at runtime
Hi,
I want to populate a Userform with Labels of text boxes at runtime. Also, if possible, I want the number of text boxes to be determined at runtime. To explain the problem I will use an analogy from Banking for adding a new customer. The form will have a dropdown box to select the type of customer. When the customer type is selected,the customer type value will be looked up in an excel sheet, where for each customer type the number of text boxes and the label values of the text boxes would be stored in a row. On selecting a customer type in the drop down box, the form should get populated with the specified number of text boxes and the labels displayed. Is this possible? Any pointers or example code would be of immense help. Any other way of approaching the problem are also welcome. Thanks in advance for all the help. Regards, Raj |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox labels at runtime
Put the maximum number of textboxes you would expect and then make the one
uses as "visible = true", and the ones you don't want as "visible = false". use code like this For BoxCount = 1 To 100 Set mybox = UserForm1.Controls("Textbox" & BoxCount) mybox.Visible = False Next BoxCount or UserForm1.TextBox1.Visible = False "Raj" wrote: Hi, I want to populate a Userform with Labels of text boxes at runtime. Also, if possible, I want the number of text boxes to be determined at runtime. To explain the problem I will use an analogy from Banking for adding a new customer. The form will have a dropdown box to select the type of customer. When the customer type is selected,the customer type value will be looked up in an excel sheet, where for each customer type the number of text boxes and the label values of the text boxes would be stored in a row. On selecting a customer type in the drop down box, the form should get populated with the specified number of text boxes and the labels displayed. Is this possible? Any pointers or example code would be of immense help. Any other way of approaching the problem are also welcome. Thanks in advance for all the help. Regards, Raj |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Textbox labels at runtime | Excel Programming | |||
adiing textbox..at runtime | Excel Programming | |||
Copying labels to Userform at runtime. | Excel Programming | |||
Deleting a textbox control at runtime | Excel Programming |