ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Optionbuttons in frame on form (https://www.excelbanter.com/excel-programming/377923-optionbuttons-frame-form.html)

Les Stout[_2_]

Optionbuttons in frame on form
 
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 ***

Tom Ogilvy

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 ***


Les[_8_]

Optionbuttons in frame on form
 
Thanks Tom, that is my code also. My bad as i did not try it but just
saw that they didi not grey out.

best regards,

Les


Tom Ogilvy wrote:
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 ***




All times are GMT +1. The time now is 03:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com