| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert comment into cell
Dear Expert,
Have 2 columns .... Column A is name Column B is type I want the content in column B to put as comments in respective column A. For example, Name Type Elton PT Jasmine PT Tony FT, 10 Kammi PT, 12 Would like to put PT as comment in cell A2 (Elton) Would like to put PT as comment in cell A3 (Jasmine) Would like to put FT, 10 as comment in cell A4 (Tony) It can certainly be done manually ... by copy, right click the cell, choose insert comment .....repeat and repeat ... I have 1000 cells to be done. Hope VBA can automate the task. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert comment to Cell | Excel Discussion (Misc queries) | |||
| Insert a File, not a Comment, to a Cell | Excel Programming | |||
| Macro to Insert Comment to a cell | Excel Programming | |||
| Macro to Insert Comment to a cell | Excel Programming | |||
| How do I insert a comment when the Insert:Comment menu is greyed? | Excel Discussion (Misc queries) | |||
![Elton Law[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
