Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening a UserForm
Sub Picture88_Click()
userform1.listbox1.rowsource = "203!A28:B44" UserForm1.Show End Sub "Danny Sowden" wrote in message ... I have created a UserForm in VBA for my Excel spreadsheet. What is the correct code to assign to a macro to open up the userform and then populate the ListBox1 the RowSource with 203!A28:B44. I have the code Sub Picture88_Click() UserForm1.Show End Sub Which opens the UserForm but i want to add the RowSource into the ListBox1 when I call the UserForm, so that i can assign different RowSources when i click different pictures. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop blank workbook from opening when opening an existing | Excel Discussion (Misc queries) | |||
Userform | Excel Worksheet Functions | |||
one userform to another | Excel Discussion (Misc queries) | |||
REF errors when opening excel in xp. works fine when opening wor. | Excel Discussion (Misc queries) | |||
userform | Excel Programming |