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