I have a combox in worksheet, not userform. I want to initialize it when I open the workbook.
Maybe I can do it on the workbook open event. but the problem is the number of worksheets and the combox in each worksheets may vary.
So I think the best way to initialize is do it per sheet.
I tried the worksheet_active events, but this event is not triggered when the workbook is open.
Sorry for my poor english. In brief, my question is:
How to initialized variables and controls in a worksheet? in which event?