well before the userform shows up on the screen it needs to upload the information that goes in the list box, therefore it should call the rowsource macro before showing the userform
OK, Please somone help, I'm getting very frustrated!!
I don't know what is going on, I've tried to use the code just as it is shown above but everytime I try to run this and other combinations of the listbox.rowsource code it errors and says "object required".
Any thoughts or ideas.
Here is the code exactly as I'm trying it.
Code:
Private Sub ListBox2_Click()
Worksheets("working").Activate
With UserFormICC
ListBox2.RowSource = "a1:a10"
.Show
End With
End Sub
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.