Formula in Comment

  • Thread starter Thread starter rkloess
  • Start date Start date
R

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
 
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)
 
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
 
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.)
 
Back
Top