Reset Combo Box with Active X Control to first value

[Learn_VBA]

I have an Excel sheet with a number of combo boxes. The one I need to rest the value for is called "Store".

How do I reset this Combox to the first value in the Named Range?

 

[My Aswer Is This]

Try:

Store.ListIndex = 0

 

[Learn_VBA]

I get an error which says "run-time error '424': Object Required.

Do I need to reference the worksheet.

The worksheet is called "Input Sheet"

 

[My Aswer Is This]

Well then we need more details. If the command button where you are running the script from is not on the same sheet as the combobox then we would need sheet names.
And what kind of combobox

Is this a activex or Form control Combobox?

 

[Learn_VBA]

I already provided the names and details above.

IT is fine, I have managed to sort the issue.

ThisWorkbook.InputSheet.Store.ListIndex=0 worked for me!

 

[My Aswer Is This]

I already provided the names and details above.

IT is fine, I have managed to sort the issue.

ThisWorkbook.InputSheet.Store.ListIndex=0 worked for me!

Show me where in your original post where you gave the sheet name.

 

[Learn_VBA]

It was in the second post

I get an error which says "run-time error '424': Object Required.

Do I need to reference the worksheet.

The worksheet is called "Input Sheet"

Show me where in your original post where you gave the sheet name.