Formula in Comment

[rkloess]

Hi!

I would like to customize a comment (Excel) by using a formula. Is tha
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

Raine

 

[Nick Hodge]

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
(e-mail address removed)

 

[fallingrock]

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

 

[Dave Peterson]

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]

THX

Rainer