show cell value as cell comment, by mycomment() ro any

[Eddy Stan]

Some help please

by cell value (customer code), i show thro' vlookup() are related details
but instead of showing as cell value, can the mobile number (which is cell
value in the master) be shown as comment in this sheet, while cursor is
placed on customer contact persone name
is this possible !! advance thanks

 

[Gord Dibben]

To add cell value to a Comment..............

Sub Comment_Add()
Dim cmt As Comment
Dim r As Range
For Each r In Range("D3100") 'adjust to suit
Set cmt = r.Comment
If cmt Is Nothing Then
Set cmt = r.AddComment
cmt.Text Text:=r.Text
End If
Next r
End Sub


Gord Dibben MS Excel MVP

 

[Eddy Stan]

hi
it is not working, may be i did not explain correctly
i have code at range a5:a10; and
i show at range b5:b10 names (using vlookup) for each code in a5:a10
the master list has has mobile number next to name, which i like to show as
comment in the name range b5:b10
master list is in the next sheet (mas!a5:h250, a is code, b is name & c is
mobile no..)
is it possible to show mobile number in b5:b10, as comments
where i have vlookup formula to show names
thank you

 

[Eddy Stan]

Hi all,
I dont know, if somebody read my query.
We get any element of an array by vlookup() or index formulas
but if there is any function which can get not only the element but the
comments in that element, it would have been superb. Am i too greedy !!

No problem. thank anyway to Mr GD.