getting a macro to change the value selected in combo box

[BM]

Hi

I am trying to get a macro to select different values from
a list in a combo box. I want it to do this automatically
but am having real trouble.

Does anyone have any advice on a fix?

Thanks

 

[Bob Phillips]

Automatically? Doesn't that defeat the purpose of a combobox?

--

HTH

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

 

[Guest]

Not sure I understand. The combo box contains a list of
values. Each of these values in turn drives a series of
calculations on a spreadsheet so that the results can be
seen at each value in the list.

What I want a macro to do is run through each scenario
automatically and paste value the result on a summary
sheet. It is basically to save the user the time of having
to go through and select each permutation separately.

Perhaps I am using the wrong method?

 

[Bob Phillips]

Certainly sound it to me. The Combobox seems superfluous. Why not just call
your macros directly with the values that can be selected from the combobox
as arguments to the macro?

--

HTH

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