| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to select a listed item?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to select a listed item?
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... -- HTH... Jim Thomlinson "Eric" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to select a listed item? | Excel Worksheet Functions | |||
| select more than one item in list | Excel Discussion (Misc queries) | |||
| How can I allow a user to select more than 1 drop down item? | Excel Worksheet Functions | |||
| select from item and show data filtred... | Excel Discussion (Misc queries) | |||
| How select an item in a list box | Excel Worksheet Functions | |||
Linear Mode
