Hello,
I have below two code which runs when option button is selected. What I want it to VBA to run when both the option button is selected.
Private Sub Commandbutton_click1 If Optionbutton1 = True then Call Macro1 Else End IfPrivate Sub Commandbutton_click1 If Optionbutton7 = True then Call Macro5 Else End If
I need to merge these two different code to one, and VBA to run only when both option button is selected.
Thanks
Keep the Forum clean :
1. Use [ code ] code tags [ /code ]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. Show appreciation to those who have helped you by clicking * Add Reputation below their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
Private Sub Commandbutton_click1 If Optionbutton1 = True then Call Macro1 Elseif Optionbutton7 = True then Call Macro5 End If
If solved remember to mark Thread as solved
sorry for not being clear. I want code something in below lines.
And if user select only Optionbutton7 and try to run the vba, he should get a message that "Please select Reward option"If Optionbutton1 = True and Optionbutton7 = True then Call Macro1 Else End iF Call Macro5
Hi, shiva_reshs,
your request is clear as mud as is as well as theses buttons are on a UserForm or in a worksheet...
Ciao,Private Sub CommandButton1_Click() If OptionButton1 And OptionButton7 Then Call Macro1 Call Macro5 ElseIf OptionButton7 = False Then MsgBox "Please select Reward option" End If End Sub
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
It is in the userform.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks