Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 396
Default 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 ***
  #2   Report Post  
Posted to microsoft.public.excel.programming
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 ***

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default 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 ***


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
user form and frame control Gixxer_J_97[_2_] Excel Programming 1 February 11th 05 10:26 PM
MAKE WHEEL MOUSE WORK ON USER FORM FRAME WITH SCROLL BAR HELP!!!!! Kenjaro Excel Programming 0 February 8th 05 02:53 AM
display contents of a worksheet in a form/frame Gixxer_J_97[_2_] Excel Programming 3 February 8th 05 02:33 AM
User Form - frame scroll with wheel mouse and cut & paste from tex Kenjaro Excel Programming 3 February 8th 05 02:31 AM
User Form Frame size Joe Derr[_2_] Excel Programming 0 October 11th 04 09:46 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"