Conditions

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

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.

Perfect! Thank you!