View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
[email protected] johnhildreth@citynet.net is offline
external usenet poster
 
Posts: 43
Default Grouped option buttons on forms

Got it.....thanks guys.

JH


On Feb 12, 2:59 pm, Tom Ogilvy
wrote:
for i = 1 to 4
set ctrl = me.controls("OptionButton" & i)
if ctrl.Value then
x = i
exit for
end if
next

There is no me.Groups(groupname).Value that will tell you the name of the
optionbutton or anything like that.

--
regards,
Tom Ogilvy