If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Key Presses to select certain text
Hi Is it possible to highlight the first word in a selected cell using keypresses only? Grateful for any advice. Best Wishes |
#2
|
|||
|
|||
Key Presses to select certain text
Colin Hayes wrote:
Hi Is it possible to highlight the first word in a selected cell using keypresses only? Grateful for any advice. Best Wishes Firstly, is this an Excel question ("cells")? If so, wrong group - we're Access groupies here. Yes, this is possible. In Access you could write an Event Procedure (VBA) to select the first word (up to the first space) on tabbing into a form field. In Excel you can do something similar with a Macro. Hang on, I'm missing the obvious here. Not everyone knows that in Office applications (and elsewhere) Control-arrow moves a word (space-delimited) and holding down Shift while you do that selects it. In Access, if you tab (or click) into a field you can hit Home, then hold Shift and Control and tap the Right arrow key. If you want to lose the extra space, release the Control key and hit the Left arrow key, still holding down Shift. In Excel you tap F2 first to edit the cell contents in-situ, and you may be able to record the whole lot as a macro, which you can then assign to a key combination. HTH Phil, London (evidently obsessed with macros and VBA) |
Thread Tools | |
Display Modes | |
|
|