Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Newbie needs an OnKey

I need some help with an OnKey event and really don;'t know a whole lot
about them.

I have a control combo box in Excel 2003, called "companies" in a work
sheet and I can't tab out of it. Is there a way I can add an OnKey
event so that after the user makes their selection in the combo box,
either the tab key or the enter key will move the focus to specific
cell called "date"?

Ideally I would like the combo box to have the focus when the sheet is
initially opened and then after the value is selected, the user either
hits the tab key or the enter key and the focus goes to the date cell.

Thanks,

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
OnKey Hernan Excel Programming 2 January 11th 06 04:18 PM
Help with using OnKey keithb Excel Programming 1 December 19th 05 11:03 PM
onkey help wardy Excel Programming 0 July 20th 04 05:49 PM
onkey peter Excel Programming 2 March 2nd 04 07:34 PM
Onkey Jase Excel Programming 1 November 17th 03 11:07 PM


All times are GMT +1. The time now is 10:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"