Author Topic: Comment Cell used in screen tip  (Read 5707 times)

0 Members and 1 Guest are viewing this topic.

mmulvenna

  • Full Member
  • ***
  • Posts: 91
Comment Cell used in screen tip
« on: May 21, 2008, 07:34:43 PM »
The comment cell is used to display the screen tip when you hover over the shape. I cant seem to put a cell reference in the comment cell. If I put sheet.1!user.part_name in the comment cell that is what is displayed in the tip(not the value of sheet.1!user.part_name). Anyone know how to user a cell refence in the commnet cell in the misc section of the shapesheet?

Thanks
Mike

Lars-Erik

  • Sr. Member
  • ****
  • Posts: 278
Re: Comment Cell used in screen tip
« Reply #1 on: May 21, 2008, 11:48:01 PM »
Tried this, but I don't have any problems. Make sure you don't put sheet.1!user.part_name between quotes.
Remove everything in the comments cell and enter this:

Code
=sheet.1!user.part_name

It should work...

(I use Visio 2007, might be usefull to know)

- Lars
« Last Edit: May 22, 2008, 12:33:47 AM by Lars-Erik »

mmulvenna

  • Full Member
  • ***
  • Posts: 91
Re: Comment Cell used in screen tip
« Reply #2 on: May 22, 2008, 09:05:00 AM »
Sorry, this was user error again.  ??? I did not put the equal sign in the formula. Another senior moment.

Please excuse my novice mistakes........

Thanks
Mike

Lars-Erik

  • Sr. Member
  • ****
  • Posts: 278
Re: Comment Cell used in screen tip
« Reply #3 on: May 22, 2008, 09:11:45 AM »
We're all human  ;D

Visio Guy

  • Administrator
  • Hero Member
  • *****
  • Posts: 1716
  • Smart Graphics for Visual People...n' Stuff
    • Visio Guy
Re: Comment Cell used in screen tip
« Reply #4 on: May 22, 2008, 09:20:58 AM »
Guys,

This is TOTALLY a normal mistake to make. The full mystery goes like this...

You see, certain ShapeSheet cells expect strings, and therefore play tricks on you.

Cells like:

  • Actions.Menu
  • Actions.SortKey
  • Actions.TagName
  • Controls.Prompt (Tip)
  • Comment
  • Hyperlink.Address
  • Hyperlink.Description
  • Hyperlink.ExtraInfo
  • Hyperlink.SubAddress
  • Prop.Format
  • Prop.Label
  • Prop.Prompt
  • Prop.SortKey
  • SmartTag.TagName
  • User.Prompt

and more, expect a string, and automatically put quotes around whatever you type. The trick, which is somewhat Excel-like, is to type "=" first.

So we select the Comment cell, then type: Sin(45)

Visio automatically makes it "Sin(45)", which for most people is pretty uninteresting.

So we try again, but this time type: =Sin(45)

Visio says: "AHA! A mathematical, or ShapeShe-etical formula! I will treat it like a formula and attempt to parse it!"

These "string" cells can be identified when you are in Formula-view in the ShapeSheet. They are the ones that display a default formula of "".
For articles, tips and free content, see the Visio Guy Website at http://www.visguy.com
Get my Visio Book! Using Microsoft Visio 2010

mmulvenna

  • Full Member
  • ***
  • Posts: 91
Re: Comment Cell used in screen tip
« Reply #5 on: May 22, 2008, 10:51:44 AM »
Thanks everyone. Although I still consider myself a novice I am learning more each day. Thanks to all for the help. ;D

Mike