Screen Tips

[fred]

Using the standard Microsoft template for invoices,
rolling over the "taxes" sell causes a screen tip to pop
up. Something like "Enter the tax rate in this cell..."

How are screen tips like this created and edited?

Thanks!

 

[Frank Kabel]

Hi
use 'Insert - Comment' for this

 

[mzehr]

Hi Fred,
Insert - Comment
Type your comment.
Go to Tools - Options - View and make sure that the
comment indicator only option is checked.

 

[Fred]

I appreciate your advice, but it is not what I am looking
for. I understand comments and have used them often.

My question refers to what I think is called screen tips.
They can pop-up like a comment at the cell or can be made
to pop-up in a balloon at the office assistant "paper
clip".

Fred.

 

[Frank Kabel]

Hi
I don't know MS Invoice template but if this a spreadsheet (and not a
userform) comments are the only things which come to my mind. If it is
a userform you could of course create tooltips

 

[Debra Dalgleish]

They're probably Data Validation input messages. There's information in
Excel's Help, and here:

http://www.contextures.com/xlDataVal04.html

 

[Harald Staff]

If it is
a userform you could of course create tooltips

Hi Frank

Please enlighten me, I need this immediately.

Best wishes Harald

 

[Gord Dibben]

Fred

You say "rolling over".

As opposed to clicking on?

If by clicking on, could be Data Validation Input Box message.

Other than that, dunno.

I have long time past altered the Invoice.xlt from Spreadsheet Solutions and
can no longer compare with yours.

Gord Dibben Excel MVP

 

[Frank Kabel]

Hi Harald
I meant setting the
ControlTipText
property of the userform element. So if you hover with the mouse over
an element a tootip appears

 

[Harald Staff]

Holy smoke. That's what extensive use of VB6 can do to a person. I use its
ToolTipText in VB6 all the time, missed it in Userforms and never noticed
its differently named equivalent. Thanks a ton, Frank, ControlTipText will
definitely do.

Best wished Harald

 

[Frank Kabel]

Hi Harald
which just leads to the question why MS hasn't implemented both
languages with some more consistency )