Mikeymike_W
Board Regular
- Joined
- Feb 25, 2016
- Messages
- 171
Hi there,
I have a userform with two option buttons and four comboboxes.
If Optminor = True then combox 1, 2 and 4 is visible. If Optmajor=true then Combobox 3 & 4 are visible.
Combobox 1 & 2 have constant list values but combobox 4 varies dependent on the value of combobox 1 & 2.
Combobox 3 has a fixed list but again combobox 4 varies dependent on the value of combobox 3.
What I am hoping to do is have a button that will make a random selection. Firstly randomly choose between the two option buttons and then between the variety of comboboxes as mentioned above.
Is this possible at all?
Thanks in advance for any help you can give,
Mike
I have a userform with two option buttons and four comboboxes.
If Optminor = True then combox 1, 2 and 4 is visible. If Optmajor=true then Combobox 3 & 4 are visible.
Combobox 1 & 2 have constant list values but combobox 4 varies dependent on the value of combobox 1 & 2.
Combobox 3 has a fixed list but again combobox 4 varies dependent on the value of combobox 3.
What I am hoping to do is have a button that will make a random selection. Firstly randomly choose between the two option buttons and then between the variety of comboboxes as mentioned above.
Is this possible at all?
Thanks in advance for any help you can give,
Mike