Need to get Value from ComboBox Form Control

Dear all,

I hope you are all well.

I have a ComboBox Form Control in one sheet. The combobox drop down list contains the name of all sheets available. Under the combobox, I have a commandbutton so when a user selects the sheet name from the ComboBox form control and clicks the CommandButton, a range from sheet1 will be copied to the selected sheet.

I have changed the form control name to "MonthDropDown".

Here's the code I am using:

Please Login or Register  to view this content.

The problem I am facing is an 'Run-Time error 9' - Subscript out of range on the range outlined in red.

Any ideas on how to Debug this error?

You assistance on this matter will be highly appreciated.

Best regards,
Filipe Oliveira.

I think you'll find the problem is with the assignation of sname ..
To prove it you could add
Msgbox sname
directly after
sname = .Shapes("MonthDropDown").ControlFormat.Value

Nice job!