Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with code
I'm trying to "transfer" info typed into a cell (activecell) into a the
comments box of another cell - but can't get it working... Sub TransferComment() Dim MyCell As String Dim CSource As String CSource = ActiveCell.Value MyCell = Application.InputBox("What Cell do you want to paste comment in?") Range(MyCell).AddComment CSource ActiveCell.ClearContents End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
Modification in the CODE to HIDE rows and columns that start with ZERO (code given) | Excel Programming | |||
Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming | |||
stubborn Excel crash when editing code with code, one solution | Excel Programming |