Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() There may be an easier way. If you can create shortcut keys to refernce the boxes then you may be able to use a SendKey command to enter the text. If you look at any window application yo uwill see an underline on some of the menu items which indicates that yo ucan access the menu by typing Alt and the character. I use this often in Office documents for saving files. I type Alt-F (for file menu) and ALT-S for save. When I'm typing on the key board it takes time to reach for the mouse to perform a save. If you can get the focus (the mouse pointer) to select the text box then you can fill the box using the Sendkey method. Sometimes just send the tab character using the SendKey wil move the focus from one object to another object. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=187353 http://www.thecodecage.com/forumz/chat.php |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Form does not allow entry in some fields | Excel Discussion (Misc queries) | |||
Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
Reset data entry fields to 0 or nothing | Excel Programming | |||
Linking Embedded Document Fields | Excel Discussion (Misc queries) | |||
Use Excel fields in Word document | Excel Discussion (Misc queries) |