Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Dear All
Following code is simple: ..... For i=1 To 7 Worksheets("Sheet"&i).Range("A1").Value = i*2 Next i ..... But if I want to do that with a TextBox how can I do that if I have TextBox1 to TextBox7: ..... For i=1 To 7 TextBox i .Value = i*2 Next i ..... How do I program the line within the loop? I know, it would not work like that. Thanks Philipp |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Runtime Error '91' Object variable or With block variable not set | Excel Discussion (Misc queries) | |||
Calculate Textbox value based on another textbox value.doc | Excel Discussion (Misc queries) | |||
Calculate Textbox value based on another textbox value | Excel Discussion (Misc queries) | |||
variable height variable width stacked bar charts | Charts and Charting in Excel | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions |