View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Optionbuttons in frame on form

if year(date) = 2006 then
frame2008.Enabled = False
end if

worked fine for me. The optionbuttons in 2008 are not grayed out, but they
are disabled nonetheless.

--
Regards,
Tom Ogilvy

"Les Stout" wrote:

Hi, i have a large frame "Comparisons" and within that frame i have 5
smaller frames with two opiton buttons in each frame, these smaller
frames are named from "2006" to "2011". I am trying to do an if
statement to check the date and if 2006 then make
frame2008.enabled=false, including the contents. In other words is it
possible to "connect" the option buttons to the frame ??

Could you please give me some suggestions/help.

thanks in advance..

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***