| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to create a comment with contents from Paste
I want to be able to create a comment for the current cell and add the
text currently in the Paste buffer. The macro works fine, but hard codes the text into the macro Range("E2729").Comment.Text Text:= _ "SteveW:" & Chr(10) & "hard code text....!" How can I get it to insert paste buffer ? -- Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i create a macro that would check the contents of cells | Excel Discussion (Misc queries) | |||
| how do i create a macro that would check the contents of cells | Excel Discussion (Misc queries) | |||
| copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro | Excel Programming | |||
| a comment plugin & copy paste directly from excel to comment ? fr. | Excel Worksheet Functions | |||
| Macro cut and paste quits, can't re-create | Excel Programming | |||
![Steve Walton[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
