Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 153
Default Tab indexing on a form with frame boxes

Good evening,

I have a workbook with three forms, and I'm trying to set the tab
indexes. On each of the forms, I have two or three frames with check
boxes and option buttons within the frame. I've set the TabIndex of
the Frame to the appropriate value in order, and then I've ordered the
controls within the form starting over at 0. However, when I use the
form and when I tab to the control within a frame, it doesn't select
the control. Any ideas? Thanks.

Frank
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,290
Default Tab indexing on a form with frame boxes

Is the TabStop property of the controls set to True?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Phrank" wrote in message ...
Good evening,

I have a workbook with three forms, and I'm trying to set the tab
indexes. On each of the forms, I have two or three frames with check
boxes and option buttons within the frame. I've set the TabIndex of
the Frame to the appropriate value in order, and then I've ordered the
controls within the form starting over at 0. However, when I use the
form and when I tab to the control within a frame, it doesn't select
the control. Any ideas? Thanks.

Frank
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 153
Default Tab indexing on a form with frame boxes

Yes. I've looked through all the other controls too, and I can't see
any that may affect this. It just doesn't make sense.

On Sun, 3 Dec 2006 19:36:54 -0800, "Jim Cone"
wrote:

Is the TabStop property of the controls set to True?

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,290
Default Tab indexing on a form with frame boxes

Are your controls labels. They will not accept the focus.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Phrank"
wrote in message
Yes. I've looked through all the other controls too, and I can't see
any that may affect this. It just doesn't make sense.



On Sun, 3 Dec 2006 19:36:54 -0800, "Jim Cone"

wrote:
Is the TabStop property of the controls set to True?

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 153
Default Tab indexing on a form with frame boxes

The controls are option buttons and check boxes. Yes, each of these
controls has a label, and I've checked, and each tabstop option is set
to false.

On Mon, 4 Dec 2006 18:59:59 -0800, "Jim Cone"
wrote:

Are your controls labels. They will not accept the focus.



  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,290
Default Tab indexing on a form with frame boxes

The Option buttons and Check boxes should have the "Tabstop" set to True.
Also, you may be confusing a caption on a control with a Label Control.
Jim Cone
San Francisco, USA

"Phrank" wrote in message ...
The controls are option buttons and check boxes. Yes, each of these
controls has a label, and I've checked, and each tabstop option is set
to false.

On Mon, 4 Dec 2006 18:59:59 -0800, "Jim Cone"
wrote:

Are your controls labels. They will not accept the focus.

  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 153
Default Tab indexing on a form with frame boxes

Everything is set to True. As for the label control, I added those
too, and I'm certain they are properly set. I just checked every
single control once again. Frustrating.

On Mon, 4 Dec 2006 19:30:26 -0800, "Jim Cone"
wrote:

The Option buttons and Check boxes should have the "Tabstop" set to True.
Also, you may be confusing a caption on a control with a Label Control.
Jim Cone
San Francisco, USA

"Phrank" wrote in message ...
The controls are option buttons and check boxes. Yes, each of these
controls has a label, and I've checked, and each tabstop option is set
to false.

On Mon, 4 Dec 2006 18:59:59 -0800, "Jim Cone"
wrote:

Are your controls labels. They will not accept the focus.

  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,290
Default Tab indexing on a form with frame boxes

One more ...
Select each frame and make sure the "cycle" property is set
to "fmCycleAllForms" and make sure the "enabled" property
is set to True for the frames and controls.
--
Jim Cone


"Phrank"
wrote in message
Everything is set to True. As for the label control, I added those
too, and I'm certain they are properly set. I just checked every
single control once again. Frustrating.

On Mon, 4 Dec 2006 19:30:26 -0800, "Jim Cone"
wrote:

The Option buttons and Check boxes should have the "Tabstop" set to True.
Also, you may be confusing a caption on a control with a Label Control.
Jim Cone
San Francisco, USA

"Phrank" wrote in message ...
The controls are option buttons and check boxes. Yes, each of these
controls has a label, and I've checked, and each tabstop option is set
to false.

On Mon, 4 Dec 2006 18:59:59 -0800, "Jim Cone"
wrote:

Are your controls labels. They will not accept the focus.

  #9   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 153
Default Tab indexing on a form with frame boxes

Yep, both set correctly. I also copied the form to another workbook
just to check to see if there was some anomoly with the current
workbook, and it was the same thing. I even deleted the frame and
controls and tried adding things back one at a time, and I simply
can't get the controls within the frame to take the focus. Oh, you
can tell the tab is stopping on the control because, I have 5 objects
in the frame, and I have to hit the tab 5 times to 'pass through' the
frame to the next tabbed object. It's just not taking the focus. I
appreciate your continued help with this.

Frank

On Mon, 4 Dec 2006 20:47:44 -0800, "Jim Cone"
wrote:

One more ...
Select each frame and make sure the "cycle" property is set
to "fmCycleAllForms" and make sure the "enabled" property
is set to True for the frames and controls.

  #10   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,290
Default Tab indexing on a form with frame boxes

Frank,
I am out of ideas, except...
Depending on what you are trying to achieve, you could
simply eliminate the Frames and replace them with a label
with a transparent background and an etched border.
The result looks exactly the same. Good luck with it.
Jim Cone

"Phrank"
wrote in message
Yep, both set correctly. I also copied the form to another workbook
just to check to see if there was some anomoly with the current
workbook, and it was the same thing. I even deleted the frame and
controls and tried adding things back one at a time, and I simply
can't get the controls within the frame to take the focus. Oh, you
can tell the tab is stopping on the control because, I have 5 objects
in the frame, and I have to hit the tab 5 times to 'pass through' the
frame to the next tabbed object. It's just not taking the focus. I
appreciate your continued help with this.

Frank

On Mon, 4 Dec 2006 20:47:44 -0800, "Jim Cone"
wrote:

One more ...
Select each frame and make sure the "cycle" property is set
to "fmCycleAllForms" and make sure the "enabled" property
is set to True for the frames and controls.

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
Optionbuttons in frame on form Les Stout[_2_] Excel Programming 2 November 23rd 06 04:58 AM
user form and frame control Gixxer_J_97[_2_] Excel Programming 1 February 11th 05 10:26 PM
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 07:02 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"