I have created a lone ComboBox on the first worksheet in Excel. However, I can't find a way to reference its object.
I inserted a module, and one of my subs can successfully reference the following value:
Sheets("Sheet1").Name
However, the following is not available and throws an error:
ComboBox1.Value
Error message is: Run-time error '424': Object required
Can someone explain how to reference this ComboBox in my worksheet? Thanks