Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default How to set Tab-to-next-field in a custom form (created with VBA)

The custom VBA form has tab order between input fields set up, but tab
behavior INSERTS tabs in the field. How to establish setting so user can tab
from one field to the next.

PS: Because some are text fields, I the "automatically advance to next field
when max characters are typed" isn't an option.



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default How to set Tab-to-next-field in a custom form (created with VBA)

Look at the TabKeyBehavior Property of your controls.

--
Regards,
Tom Ogilvy

"jenelle" wrote in message
...
The custom VBA form has tab order between input fields set up, but tab
behavior INSERTS tabs in the field. How to establish setting so user can

tab
from one field to the next.

PS: Because some are text fields, I the "automatically advance to next

field
when max characters are typed" isn't an option.





  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default How to set Tab-to-next-field in a custom form (created with VB

Tom,

The TabKeyBehavior is set to false for the text fields; the cbo fields don't
have this property.

However, the Help for TKB sez that the tab settings are only recognizedif
Multiline is set to true. This is seemingly illogical: I don't want
Multiline allowed for fields like date, name.

???...I haven't tested this multiline yet--Can you explain the rationale.
Maybe I'm reading Help incorrectly?


"Tom Ogilvy" wrote:

Look at the TabKeyBehavior Property of your controls.

--
Regards,
Tom Ogilvy

"jenelle" wrote in message
...
The custom VBA form has tab order between input fields set up, but tab
behavior INSERTS tabs in the field. How to establish setting so user can

tab
from one field to the next.

PS: Because some are text fields, I the "automatically advance to next

field
when max characters are typed" isn't an option.






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
custom created table styles TinaW Excel Worksheet Functions 6 October 25th 09 08:11 PM
custom field with custom formula in pivot table! Sedaghat Nejad Excel Worksheet Functions 2 June 21st 09 11:19 AM
Active X Controls Tabbing from Form Field 2 Form Field Tfrup12 Excel Discussion (Misc queries) 0 February 19th 08 08:15 PM
How to make a field created a part of the Pivot Table Field List? drhell Excel Discussion (Misc queries) 0 January 29th 07 11:13 PM
I created a form on excel. want to edit the form without printing Oz Excel Discussion (Misc queries) 1 September 1st 05 08:18 PM


All times are GMT +1. The time now is 10:25 AM.

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"