Conditions

[Guest]

Hi all,

I am creating a form and have two togglebuttons and a combobox. I want it so that if the first togglebutton is pressed, the list in the combobox stays the same, but if the 2nd togglebutton is selected, a different list comes up in the combobox.


Can anyone help with this one?

 

[Ian Mac]

Is this a real form or 1 on the sheet itself using Controls Toolbox activex objects, if the latter then i can help you.

Ian Mac

 

[Guest]

It's a form I designed myself using VBA

 

[Audiojoe]

instead of filling the combobox on the userform.initialise event do it on the
toggle button click event as follows:

sub togglebutton1.click ()

if togglebutton1.value = true then
combobox1.clear
combobox1.additem "something1"
combobox1.additem "something2"
combobox1.additem "something3"
combobox1.additem "something4"
end if

end sub

you need to clear the combobox first otherwise it will just keep adding to it.

 

[Guest]

Perfect! Thank you!