Help For Option Button for Excel VBA Form

[excelway]

I have an excel User form containing the following objects.
1. 2 option buttons (Name of Option Button1=Admin, Name of Option Button2=Operation)
2. 1 List Box
3. 2 List on Excel Sheet Name Admin and Operation
I want that if someone select Option Button1(Admin) the List Box Show only the Admin List and similarly if someone select Option Button2(Operation),list box show only Operation List
In my mind I have the following code but it is not working

If OptionButton5 = True Then
ListBox1.RowSource = "Admin"
Else if OptionButton6 = True then
ListBox1.RowSource = "operation"
End if

Also please let me know that where to put this code.

Thanks

 

[My Aswer Is This]

Try this:

Private Sub Admin_Click()
ListBox1.RowSource = "Admin"
End Sub

Private Sub Operation_Click()
ListBox1.RowSource = "Operation"
End Sub

Double click the option button and paste the code in the button

 

[excelway]

Yes, It is working now.Thanks alot

 

[My Aswer Is This]

Glad I was able to help you. Come back here to Mr. Excel next time you need additional assistance.

Yes, It is working now.Thanks alot