Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
copy comments from one cell into adjacent cell
Yes - the 'getcomment' is in the user defined (well, it actually says Personal.xls!Thisworkbook.GetComment Once selected... this baby comes up in the input field.. =PERSONAL.XLS!ThisWorkbook.GetComment() As well as a prompt box that says. "Choose the Help button for help on this funciton...- salmonman
- Post #5
- Forum: Microsoft: Office
-
copy comments from one cell into adjacent cell
Hey there - thanks for the reply. Still having troubles though - I'm quite new at Visual basic. What I tried was copying the code into my personal.xls - and then inserting the function in excel by clicking on the function button - user defined - personal.xls-this workbook - Get comment. Any...- salmonman
- Post #3
- Forum: Microsoft: Office
-
copy comments from one cell into adjacent cell
I am trying to copy the comments text from one cell into an adjacent cell. Is there an excel formula for this? Ex.. Cell B3 (Value = 4, red triangle comment says "This means 4 apples" I want cell C3 to have text in it saying "This means 4 apples". Any help is appreciated. Thanks.- salmonman
- Thread
- Replies: 7
- Forum: Microsoft: Office
