View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
 
Posts: 964
Default Pop-Ups in a spreadsheet?

One possible option might be datavalidation, select the cell in question,
do datavalidation click on the input message tab and type in the address
and ph there.
Now every time you select that cell a message will pop up.

--


Regards,


Peo Sjoblom

"Judi<<" wrote in message
...
Good Morning,
I have been learning Access lately, so I might just be expecting too much
from Excel, please bear with me in this matter.

I have a spreadsheet with a list of salesmen, their "assistants", their
region, and the estimator who works with them. I need to add phone numbers
and fax numbers for the salesmen, but I do not want to add more fields in
the
sheet because I don't want to make it smaller on the screen, or have to
scroll over to see them.

What I want to do is add something that I can either click on or hover
over
that will pop-up with the salesman's phone and fax information. I know I
could add a comment on each one, and that is certainly an option, even if
it's not what that's really intended for.

Like I said, I have been working with Access, so I might just expect other
programs to do more because it does so with the relational stuff. This
needs
to be in Excel, so I need to work out how to do this here.

Thank you to anyone who might be able to help me. Please try to avoid
programing or macros because I'm completely ignorant of how to even use
that
stuff. I am learning, but I'm not there yet.