I'm trying to populate a ComboBox located in a userform with all of the
worksheet names in the workbook. I'm having problems getting this to work.
I found the following code in an earlier post, but no success:

for each sh in activeworkbook.sheets
combobox1.additem sh.name
next

How do I do this and where should the lines of code be located in the
overall code? What kind of sub procedure is this in (if any)?

Thanks for your help! (I'm very new to VBA and am learning as I go...)

-Mark