Hello
I'd like a userform listbox to update while the userform is visible. I'd like to click on an option button and the listbox below the button then update the list of items based on which option button is selected.
Something like
Seems the userform would need to "refresh" based on option button choice.
Thanks for any help
Tom
I'd like a userform listbox to update while the userform is visible. I'd like to click on an option button and the listbox below the button then update the list of items based on which option button is selected.
Something like
VBA Code:
if optionbutton 1 = true then listbox.list = Array("Iron", "Copper", "Nickel")
if optionbutton 2 = true then listbox.list = Array("Titanium", "Cobalt", "Zinc")
Seems the userform would need to "refresh" based on option button choice.
Thanks for any help
Tom