-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Remove comments from tooltip insert value into adjacent cell
- Thread starter AustinATL
- Start date
HalfAce
MrExcel MVP
- Joined
- Apr 6, 2003
- Messages
- 9,456
Hello Austin,
Kind of a lot of gray area as to what exactly you're doing but perhaps this will
give you a start.
If you intend to use vba and if by 'adjacent cell' you mean the next cell to the right
then something like this should help.
If this is not what you're looking for then post back with more details and we'll see
where we need to go from here.
Kind of a lot of gray area as to what exactly you're doing but perhaps this will
give you a start.
If you intend to use vba and if by 'adjacent cell' you mean the next cell to the right
then something like this should help.
Code:
Selection.Offset(, 1).Value = Selection.Comment.Textwhere we need to go from here.
Upvote
0
DominicB
Well-known Member
- Joined
- Oct 3, 2005
- Messages
- 1,569
Good evening AustinATL
You code use a really simple custom function like this :
Stick the code into a norml module, and then use something like this in B1 to show the comment in A1 :
=CellComm(A1)
HTH
DominicB
You code use a really simple custom function like this :
Code:
Function CellComm(Rng As Range)
Application.Volatile
CellComm = Application.WorksheetFunction.Substitute(Rng.Comment.Text, Chr(10), "")
End FunctionStick the code into a norml module, and then use something like this in B1 to show the comment in A1 :
=CellComm(A1)
HTH
DominicB
Upvote
0
Similar threads
