Change value of combobox

[EOAEvan]

I want to change the value of a combobox from within a sub. Im attempting to use

ComboBox3.Value = "ACTvsPLN"

but am getting a "Object required" error. Do I need to create or define the object? If so, how?

Thanks!

 

[Norie]

Where is the combobox located and how did you create it?

Also where is the code located and how are you running it?

 

[EOAEvan]

Where is the combobox located and how did you create it?
Also where is the code located and how are you running it?

The combo box will be on the same "active sheet", it was created using a active X control combo box.

The code I am using now is located in a sub within a module. It seems using

 ActiveSheet.ComboBox2.Value = "ACTvsPLN"

works but Im curious why it wasnt working the other way? Is it simply because it didnt know where to find the object?

There is code within the combo box that runs on a change event. What this is doing is when a main macro is run it will set columns to a "default" formula which is why I want to start off by setting the combo box to a specific value. Then user can to change the combo box to show other formulas if they so choose.