| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pasting in cell comments
Hi,
Thanking you for any assistance in advance. Can you please tell me if it is possible to use VBA to allow pasting into cell comments. I am wanting to take info from one spreadsheet and insert it as a cell comment in another. Many regards John |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
pasting in cell comments
This should do it.
Sub comnt() 'assign cell value to a string variable Range("a2").Select Dim tst As String tst = ActiveCell.Value 'apply variable to the desired location Range("d2").NoteText tst End Sub "John Contact" wrote: Hi, Thanking you for any assistance in advance. Can you please tell me if it is possible to use VBA to allow pasting into cell comments. I am wanting to take info from one spreadsheet and insert it as a cell comment in another. Many regards John |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
pasting in cell comments
Thanks DMoney, worked great
"DMoney" wrote: This should do it. Sub comnt() 'assign cell value to a string variable Range("a2").Select Dim tst As String tst = ActiveCell.Value 'apply variable to the desired location Range("d2").NoteText tst End Sub "John Contact" wrote: Hi, Thanking you for any assistance in advance. Can you please tell me if it is possible to use VBA to allow pasting into cell comments. I am wanting to take info from one spreadsheet and insert it as a cell comment in another. Many regards John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract Cell Comments and Paste as text in a cell | Excel Worksheet Functions | |||
| Pasting into Excel comments | Excel Discussion (Misc queries) | |||
| Copying cell contents from many cells and pasting into one cell | Excel Discussion (Misc queries) | |||
| Need to add cell comments in unlocked cell on protected worksheet | Excel Discussion (Misc queries) | |||
| Pasting on Filtered Data Sheets without pasting onto hidden cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
