Hi,
I have a number of combobox's which I've created from the Forms toolbar and
they each have a macro assigned to them. The user just needs to select a
variable for each, but for demonstration purposes, I am trying to write
another macro which populates the combobox's with certain values. For
example, if the first combobox has an input range of A, B, C and D, and the
second combobox has an input range of 10, 20, 30 and 40, I am trying to get a
macro which automatically selects B and 40 for a scenario which I am trying
to demo.
Thank you in advance.
Graeme

If you have your combo boxes linked to a cell, you can set the value of the
link cell with the correct index and the combobox will update. For example,
if your combo box 1 is linked to A1 and combo box 2 is linked to A2, you can
set A1 to 2 for "B" and A2 to 4 for "40".



--
Hope that helps.

Vergel Adriano


"Graeme" wrote:

> Hi,
> I have a number of combobox's which I've created from the Forms toolbar and
> they each have a macro assigned to them. The user just needs to select a
> variable for each, but for demonstration purposes, I am trying to write
> another macro which populates the combobox's with certain values. For
> example, if the first combobox has an input range of A, B, C and D, and the
> second combobox has an input range of 10, 20, 30 and 40, I am trying to get a
> macro which automatically selects B and 40 for a scenario which I am trying
> to demo.
> Thank you in advance.
> Graeme

thank you

"Vergel Adriano" wrote:

> If you have your combo boxes linked to a cell, you can set the value of the
> link cell with the correct index and the combobox will update. For example,
> if your combo box 1 is linked to A1 and combo box 2 is linked to A2, you can
> set A1 to 2 for "B" and A2 to 4 for "40".
>
>
>
> --
> Hope that helps.
>
> Vergel Adriano
>
>
> "Graeme" wrote:
>
> > Hi,
> > I have a number of combobox's which I've created from the Forms toolbar and
> > they each have a macro assigned to them. The user just needs to select a
> > variable for each, but for demonstration purposes, I am trying to write
> > another macro which populates the combobox's with certain values. For
> > example, if the first combobox has an input range of A, B, C and D, and the
> > second combobox has an input range of 10, 20, 30 and 40, I am trying to get a
> > macro which automatically selects B and 40 for a scenario which I am trying
> > to demo.
> > Thank you in advance.
> > Graeme