TheGreatest
12-15-2004, 03:16 AM
Hi,
I have a Workbook which contains 40 worksheets. I created a UserForm and I have a ComboBox and a ListBox on the UserForm.
ComboBox will show the sheet names to pick and ListBox will show the data in Range(C35:K61) on the sheet which picked by the combobox.
I menaged ComboBox to work in order but couldn't managed the ListBox to show the data.
Any help would be appreciated...
Regards
I have a Workbook which contains 40 worksheets. I created a UserForm and I have a ComboBox and a ListBox on the UserForm.
ComboBox will show the sheet names to pick and ListBox will show the data in Range(C35:K61) on the sheet which picked by the combobox.
I menaged ComboBox to work in order but couldn't managed the ListBox to show the data.
Any help would be appreciated...
Regards