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. |
All times are GMT +1. The time now is 04:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com