Macro that changes Drop Down Box

[peekbo]

I am writing a macro that will execute each time the file is opened.
am doing this so that all the values reset to default values. However
I have nurmerous drop down boxes on the inputs page and cannot figur
out how or if its possible to have a macro select a value in a dro
down box.

Any thoughts or idea would be apprecaited.

Thanks,
Bria

 

[Bob Phillips]

Brian,

What sort of dropdowns?

If Data Validation, just set the value of the host cell.

If Forms combobox, Activesheet.DropDowns("Drop Down 1").ListIndex=3

If Control Toolbox, Activesheet.OLEObjects("Combobox1").object.Listindex=4

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Dave Peterson]

See another reply at your other post.

I am writing a macro that will execute each time the file is opened. I
am doing this so that all the values reset to default values. However,
I have nurmerous drop down boxes on the inputs page and cannot figure
out how or if its possible to have a macro select a value in a drop
down box.

Any thoughts or idea would be apprecaited.

Thanks,
Brian