Hi Guys,
I need to generate a lot of data and am wondering if a macro can help
to select the combo boxes for me. I have a "main" subject combo box and
then 4 "sub set" combo boxes under this

eg

Main Combo - Drinks
Choices Coffee, Tea, wine , beer

sub Combo 1 - Temperature

Hot, cold, chilled, room temperature


sub Combo 2 - Cost
$1,$2,$3

sub Combo 3 - Drink with

Cookie, crisps, apple,

(unlike this example all combinations are valid!!)

So each main topic must be manually selected, then every combination
under it gone through with a "macro" selecting the sub set combos. Once
each combination is selected an existing macro button is pushed to
generate the data based on the combo box selections, the process is
then repeated (next main subject selected manually all sub set
combinations gone through and data generated for each...)

FYI
the combo boxes already have small macros attached to them for other
things

Any ideas!!?

Cheers

Simon


--
simonsmith
------------------------------------------------------------------------
simonsmith's Profile: http://www.excelforum.com/member.php...o&userid=34235
View this thread: http://www.excelforum.com/showthread...hreadid=548619