Formula in Comment

Hi!

I would like to customize a comment (Excel) by using a formula. Is that possible in any way?

The solution is supposed to look like this:

Entered data in Cell: eg. Steel 1 Comment: weight per foot 10lbs
Entered data in Cell: eg. Steel 3 Comment: weight per foot 5 lbs
Entered data in Cell: eg. Pipe Comment: weight per foot 1 lbs
Entered data in Cell: empty Comment: Enter type of material

THX

Rainer

You can use the Equation Editor in Word to create a formula. Then save the document as a HTML format. This will convert the formula to a GIF file. Paste the GIF file into the Excel comment.

This is not possible through the User Interface. It would be possible using
code, but would be 'cludgy' in comparison to using another cell and a
VLOOKUP to display the result

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"rkloess" <rkloess.1t3kma_1122919501.4847@excelforum-nospam.com> wrote in
message news:rkloess.1t3kma_1122919501.4847@excelforum-nospam.com...
>
> Hi!
>
> I would like to customize a comment (Excel) by using a formula. Is that
> possible in any way?
>
> The solution is supposed to look like this:
>
> Entered data in Cell: eg. Steel 1 Comment: weight per foot 10lbs
> Entered data in Cell: eg. Steel 3 Comment: weight per foot 5 lbs
> Entered data in Cell: eg. Pipe Comment: weight per foot 1 lbs
> Entered data in Cell: empty Comment: Enter type of material
>
> THX
>
> Rainer
>
>
> --
> rkloess
> ------------------------------------------------------------------------
> rkloess's Profile:
> http://www.excelforum.com/member.php...o&userid=25783
> View this thread: http://www.excelforum.com/showthread...hreadid=391867
>

You could create a userdefined function that might be able to do what you want,
but I wouldn't go that route.

I'd just insert an adjacent column and put a formula in those cells that
returned the string I wanted.

I'd add a new worksheet, put the values in column A and the Comments in column
B.

Then use a formula like this:

=if(a1="","Enter type of material",vlookup(a1,sheet2!a:b,2,false))

By putting these comments in a real cell (instead of a comment), you can sort,
autofilter, and lots of other stuff. If you put that text in comments, it'll
soon become a real bear to work with. (Just my $0.02.)

rkloess wrote:
>
> Hi!
>
> I would like to customize a comment (Excel) by using a formula. Is that
> possible in any way?
>
> The solution is supposed to look like this:
>
> Entered data in Cell: eg. Steel 1 Comment: weight per foot 10lbs
> Entered data in Cell: eg. Steel 3 Comment: weight per foot 5 lbs
> Entered data in Cell: eg. Pipe Comment: weight per foot 1 lbs
> Entered data in Cell: empty Comment: Enter type of material
>
> THX
>
> Rainer
>
> --
> rkloess
> ------------------------------------------------------------------------
> rkloess's Profile: http://www.excelforum.com/member.php...o&userid=25783
> View this thread: http://www.excelforum.com/showthread...hreadid=391867

--

Dave Peterson

THX

Rainer