View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patrick C. Simonds Patrick C. Simonds is offline
external usenet poster
 
Posts: 343
Default Optionbutton Group test

I have 7 OptionButtons on my UserForm. They are all have the same GoupName,
which is Status. Is there any way to test the Group to ensure at least 1
option is selected.

What I am looking for is a msgbox to popup saying "You must select at least
1 option prior to continuing"

I know I can use an If Statement to check each OptionButton but thought it
would be cleaner if I could just check the Group.