ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Going from one combo to another (https://www.excelbanter.com/excel-discussion-misc-queries/57912-going-one-combo-another.html)

bernardoafs

Going from one combo to another
 

I have a worksheet with some combo boxes. I want to hit the tab key and
move from one combo to the next one. Is that possible? How is it done?


--
bernardoafs
------------------------------------------------------------------------
bernardoafs's Profile: http://www.excelforum.com/member.php...o&userid=28993
View this thread: http://www.excelforum.com/showthread...hreadid=489382


Nigel

Going from one combo to another
 
Hi,

if you open goto your userform properties, there is an area called Tab
Index. alter the numbers to your tab preference as they are automatically set
by the point you added your combo box. i would suggest going to your first
combo box you want to start with and setting it at 1 the select the boxes
according to your desired rotation and setting the tab index numerically as
required.


Regs,

Nigel


"bernardoafs" wrote:


I have a worksheet with some combo boxes. I want to hit the tab key and
move from one combo to the next one. Is that possible? How is it done?


--
bernardoafs
------------------------------------------------------------------------
bernardoafs's Profile: http://www.excelforum.com/member.php...o&userid=28993
View this thread: http://www.excelforum.com/showthread...hreadid=489382




All times are GMT +1. The time now is 12:21 AM.

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