How to select a listed item?
Since you're planning on using keystrokes anyway....
How about this:
With A1 selected
[Alt]+down_arrow........displays the dropdown list
Use arrow keys to select an item....Press [Enter]
Is that something you can work with?
***********
Regards,
Ron
XL2003, WinXP
"Eric" wrote:
There is a list of items in cell A1, such as
A and B
I would like to create a macro shortcut to change the value of cell A1, such
as
if I click Ctrl+Shift+A, then A will be selected in cell A1,
if I click Ctrl+Shift+B, then B will be selected in cell A1,
Does anyone have any suggestions on how to do it?
Thanks in advance for any suggestions
Eric
|