Hi All,

I have a worksheet which contains combox and textboxes i have written a macro to fill the comboboxes with values.

My problem is this macro works only when i press F5 or if i select the macro and click on the run button.

Is there a way to automatically run the macro on opening the worksheet.
if so where/what code to be written to make this process run?

Plz help me out