Doflamingo
Board Regular
- Joined
- Apr 16, 2019
- Messages
- 238
Hi all,
I have created a userform,
There are 2 conditions
The 1st condition with optionbutton1 and obtionbutton2 (they represent either ''Male'' or ''Female'')
The 2nd condition with optionbutton3, optionbutton4, optionbutton5 and optionbutton6 (they represent ''less than 18 years old", "between 18-30 years old", "between 30-50 years old" and the last one "more than 50 years old")
With those 2 conditions I would like to make appear in the listbox1:
if optionbutton1 and optionbutton3 are selected, the value in the listbox1 would be blank
if optionbutton1 and optionbutton4 are selected, the value in the listbox1 would be "ID"
if the optionbutton1 and optionbutton5 are selected the values in the listbox1 would be "ID" and below "Proof of Residence"...
Any ideas about how to link different optionbuttons to listbox ?
Here is the screenshot
https://www.dropbox.com/s/ltzai0gnsterb8v/Untitled.png?dl=0
Here is the beginning of the code
I have created a userform,
There are 2 conditions
The 1st condition with optionbutton1 and obtionbutton2 (they represent either ''Male'' or ''Female'')
The 2nd condition with optionbutton3, optionbutton4, optionbutton5 and optionbutton6 (they represent ''less than 18 years old", "between 18-30 years old", "between 30-50 years old" and the last one "more than 50 years old")
With those 2 conditions I would like to make appear in the listbox1:
if optionbutton1 and optionbutton3 are selected, the value in the listbox1 would be blank
if optionbutton1 and optionbutton4 are selected, the value in the listbox1 would be "ID"
if the optionbutton1 and optionbutton5 are selected the values in the listbox1 would be "ID" and below "Proof of Residence"...
Any ideas about how to link different optionbuttons to listbox ?
Here is the screenshot
https://www.dropbox.com/s/ltzai0gnsterb8v/Untitled.png?dl=0
Here is the beginning of the code
Code:
Private Sub UserForm_Initialize()
TextBox1.Value = ""
OptionButton1.Value = True
OptionButton2.Value = True
OptionButton3.Value = True
OptionButton4.Value = True
OptionButton5.Value = True
OptionButton6.Value = True
End Sub