Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
show cell value as cell comment, by mycomment() ro any
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
show cell value as cell comment, by mycomment() ro any
To add cell value to a Comment..............
Sub Comment_Add() Dim cmt As Comment Dim r As Range For Each r In Range("D3:D100") '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 On Wed, 22 Apr 2009 13:42:01 -0700, Eddy Stan wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
show cell value as cell comment, by mycomment() ro any
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 "Gord Dibben" wrote: To add cell value to a Comment.............. Sub Comment_Add() Dim cmt As Comment Dim r As Range For Each r In Range("D3:D100") '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 On Wed, 22 Apr 2009 13:42:01 -0700, Eddy Stan wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
show cell value as cell comment, by mycomment() ro any
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. "Eddy Stan" wrote: 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 "Gord Dibben" wrote: To add cell value to a Comment.............. Sub Comment_Add() Dim cmt As Comment Dim r As Range For Each r In Range("D3:D100") '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 On Wed, 22 Apr 2009 13:42:01 -0700, Eddy Stan wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show Excel comment on mouseover but not the comment indicator | Excel Programming | |||
How can I show/hide the cell comment blocks ? | New Users to Excel | |||
show or Hide cell comment when mouse hovers in Excel? | Excel Worksheet Functions | |||
How to show original comment in cell when using Vlookup in Excel? | Excel Worksheet Functions | |||
Show Comment when in the cell | Excel Worksheet Functions |