| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to know what is selected
Hi,
To a routine, I need to know what is selected on worksheet_change and worksheet_selectionchange. I need It to take different actions depending on the type... Selections could be like Cells Buttons CheckBoxes TextBox Worksheets ChartObjects Most important right now is to find if it is a button selected (in the shapes collection i think, not OLE). The other types in the list will soon come to, however. Can somebody please share a good routine for this? /Regards |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple cells or columns are selected instead of selected cell or | Excel Discussion (Misc queries) | |||
| Cells are selected but aren't displayed as selected | Excel Discussion (Misc queries) | |||
| Cells are selected but aren't displayed as selected | Excel Worksheet Functions | |||
| Macro to take selected cells times a selected cell | Excel Programming | |||
| how do i make it so that when a sheat is selected either via link or tab, that xlLastCell is selected. the last on the sheet. | Excel Worksheet Functions | |||
![Maria J-son[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
