looking to being able to right click in a range of cells and have a list show up with preset string options, then upon selecting one for a Comment to be inserted into that cell with chosen string
Insert Comment into a cell from a list of string options
-
acat -
November 9, 2019 at 7:49 PM -
Thread is marked as Resolved.
-
-
-
The only way I know to do it would be a context menu for all cells or none. I guess you could code the macros to act on a range of cells or do nothing if selected. For examples, see: http://www.rondebruin.nl/win/s6/win001.htm
-
What about a right-click which would display a simple UserForm listing all possible choices ...???
-
Can you attach a dummy workbook showing the list and where you want it to be used.
-
This uses an ActiveX ListBox to display the list.
After selecting an item it is added to a comment in the cell
-
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!