natekris8183
Board Regular
- Joined
- Mar 12, 2013
- Messages
- 156
I have looked around and I understand how to either use Case Select or If to justify whether or not to proceed. The problem I have is I have a set of OptionButtons on a Userform. It defaults on Activate to what is the standard delivery day for that particular location. However, due to holidays, it can fluctuate so I wanted to leave the option to change the delivery day, but it is an EXCEPTION. So I want to prompt the radio button, when clicked, that if it's not the standard day (justified by the vlookup of the day associated in a table for that location), that is activates a Yes/No msgbox with "Change delivery day?". The solution will be that if you select "No" (iAns = vbNo) then it cancels he action of selecting the OptionButton. I would want the standard one to stay selected. Now I know I can put a loop with For Each for the vbNo response to go back and reselect the appropriate button, but to have it toggle back-and-forth seems rather extensive. I am assuming there has to be some syntax to just cancel the action of OptionButton_Click.