Colin said:
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)
