ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Message Box (https://www.excelbanter.com/excel-discussion-misc-queries/204084-message-box.html)

John Moore

Message Box
 
How do I have a message show up when a cell is clicked .... i.e. I want the
cells in a particular coulmn ( say C ) that when I click on one cell ,,, say
C3 ,,,, a message box appears with a message ... without using VBA ?

Kevin B

Message Box
 
Without using VBA there isn't a way to get a message box to pop up when
clicked. However, you can click on a cell and display an inserted comment.

Click INSERT on the menu and select COMMENT. Enter your text message in the
displayed comment box
--
Kevin Backmann


"John Moore" wrote:

How do I have a message show up when a cell is clicked .... i.e. I want the
cells in a particular coulmn ( say C ) that when I click on one cell ,,, say
C3 ,,,, a message box appears with a message ... without using VBA ?


Dave Peterson

Message Box
 
Maybe you could use Data|Validation (xl2003 menus)

You can specify the message on the "input message" tab of that dialog.

This is the opposite of a comment. You actually have to select the cell to see
the message--not just mouse over it.

John Moore wrote:

How do I have a message show up when a cell is clicked .... i.e. I want the
cells in a particular coulmn ( say C ) that when I click on one cell ,,, say
C3 ,,,, a message box appears with a message ... without using VBA ?


--

Dave Peterson

John Moore

Message Box
 
Thanks Dave. ONce again you come up trumps.

"Dave Peterson" wrote:

Maybe you could use Data|Validation (xl2003 menus)

You can specify the message on the "input message" tab of that dialog.

This is the opposite of a comment. You actually have to select the cell to see
the message--not just mouse over it.

John Moore wrote:

How do I have a message show up when a cell is clicked .... i.e. I want the
cells in a particular coulmn ( say C ) that when I click on one cell ,,, say
C3 ,,,, a message box appears with a message ... without using VBA ?


--

Dave Peterson



All times are GMT +1. The time now is 08:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com