How to select a listed item?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Refer to the post in Worksheet functions

Does anyone have any suggestions on how to select a listed item?

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 you in advance for any suggestions
Eric
 
You are out of luck on this one. There is no automated way via macro or
otherwise to select only a protion of a cell's contents. Your only optoin is
to manually select the portion you want...
 
Back
Top