| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"tabbing" from one element to the other
I have a spreadsheet with a few combo boxes and text boxes on it. I want that when the user is using control1 by pressing the tab key he should be switched to control2. For some reason .setFocus and .Activate are nto working! Please help! -- schoujar ------------------------------------------------------------------------ schoujar's Profile: http://www.excelforum.com/member.php...o&userid=26574 View this thread: http://www.excelforum.com/showthread...hreadid=480973 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
"tabbing" from one element to the other
Hello schoujar, In the properties sheet for the controls you will find TabIndex and TabStop. TabIndex is a sequential number that is assigned to a control when it is created. It has a companion property TabStop that is a boolean value (True/False). If TabStop is True, the control will receive the focus when the user press the Tab key. The order in which Tabbing occurs is set by TabIndex. It starts at 0 and increases by 1. You can reset the TabIndex of the controls to match your layout. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=480973 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
"tabbing" from one element to the other
Hello schoujar, In the properties sheet for the controls you will find TabIndex an TabStop. TabIndex is a sequential number that is assigned to a contro when it is created. It has a companion property TabStop that is boolean value (True/False). If TabStop is True, the control wil receive the focus when the user press the Tab key. The order in whic Tabbing occurs is set by TabIndex. It starts at 0 and increases by 1 You can reset the TabIndex of the controls to match your layout. Sincerely, Leith Ros -- Leith Ros ----------------------------------------------------------------------- Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846 View this thread: http://www.excelforum.com/showthread.php?threadid=48097 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
"tabbing" from one element to the other
thats what I would have thought. But my properties window doesn't eve show the tabindex and tabstop properties. Whats wrong? By the way these elements are not on a form. They are individuall placed on a worksheet. Would that be a problem -- schouja ----------------------------------------------------------------------- schoujar's Profile: http://www.excelforum.com/member.php...fo&userid=2657 View this thread: http://www.excelforum.com/showthread.php?threadid=48097 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| How to "return" the array element number in VBA | Excel Discussion (Misc queries) | |||
| "tabbing" from one element to the other | Excel Programming | |||
| "Tabbing" code crashing xl2002 WinXP | Excel Programming | |||
| "for each element in group" question | Excel Programming | |||
![schoujar[_14_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
