ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Data validation cell default (https://www.excelbanter.com/excel-programming/355053-data-validation-cell-default.html)

goeppngr[_2_]

Data validation cell default
 

I have a cell that contains data validation. It contains three
selections. If I have three sections there is nothing written in the
cell to tell the person filling out the form to select from the list.
Is there a way that I can get put in that cell something that says
"Select from list" in which then the user will go to that cell and can
select from the three choices?


--
goeppngr
------------------------------------------------------------------------
goeppngr's Profile: http://www.excelforum.com/member.php...o&userid=30906
View this thread: http://www.excelforum.com/showthread...hreadid=518835


Tom Ogilvy

Data validation cell default
 
select the cell and select data =Validation

Click on the "Input Message" tab and type in your message and select the
checkbox at the top to show the message when the cell is selected.

--
Regards,
Tom Ogilvy


"goeppngr" wrote in
message ...

I have a cell that contains data validation. It contains three
selections. If I have three sections there is nothing written in the
cell to tell the person filling out the form to select from the list.
Is there a way that I can get put in that cell something that says
"Select from list" in which then the user will go to that cell and can
select from the three choices?


--
goeppngr
------------------------------------------------------------------------
goeppngr's Profile:

http://www.excelforum.com/member.php...o&userid=30906
View this thread: http://www.excelforum.com/showthread...hreadid=518835





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

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