LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dre Dre is offline
external usenet poster
 
Posts: 2
Default Tab order with check boxes

Hi

How do I incorporate check boxes into my tab order? I'm creating an
excel client form where someone must fill in data in either text, check
boxes and/or drop down lists. I've used the following to set the tab
order

Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case "$B$4"
Range("G4").Select
Case "$G$4"
Range("J4").Select
Case "$J$4"
Range("B5").Select
End Select
End Sub

which works for text boxes and drop down lists, but not check boxes.

Any ideas?
Thanks,
Dre

 
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
Linked Check Boxes blueegypt Excel Discussion (Misc queries) 4 May 12th 06 10:36 PM
Can one cell hold multiple check boxes (and then sort based off e. OT Excel Discussion (Misc queries) 1 March 29th 06 07:32 PM
why do check boxes move when printing excel spreadhseets Simon Jefford Excel Discussion (Misc queries) 3 June 22nd 05 02:04 PM
Check Boxes vknight Excel Discussion (Misc queries) 1 June 20th 05 11:13 AM
How to align check boxes on an Excel sheet? CC Excel Worksheet Functions 2 February 16th 05 03:27 PM


All times are GMT +1. The time now is 07:03 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"