Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On Nov 11, 1:30*pm, Dave Peterson wrote:
If you name your user forms nicely, you can use those variables. Is this in the UserForm_Initialize routine? I'm guessing yes... 'just to prove that we found it for x = lbound(con) to ubound(con) * *me.controls("textbox" & x).value = con(x) next x (this used the first suggestion--not treating con() as a range). jlclyde wrote: Dave, I shoudl have also asked on how to set text boxes with the same numbering system. *I am trying to find 1 to 6 for convert runs, which you have done so very nicely. *I also need to set the values of text boxes on a userform. *This is all happening at the intialize phase. Thanks, Jay -- Dave Peterson Dave, This is incredible stuff. Thank you for taking the time to respond. This is exactly what I need and will help me out in many other applications and forms that I have floating around. Thanks, Jay |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Setting multiple conditions to return a figure from multiple cells | Excel Discussion (Misc queries) | |||
Confused about setting up functions based on variables? | Excel Worksheet Functions | |||
Use a loop to create multiple Charts - Suggestions ? | Charts and Charting in Excel | |||
VLOOKUP loop multiple times | Excel Worksheet Functions | |||
Setting up some sort of cutting and pasting loop | Excel Worksheet Functions |