ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Adding a cell instruction for the user (https://www.excelbanter.com/excel-discussion-misc-queries/131649-adding-cell-instruction-user.html)

kerri

Adding a cell instruction for the user
 
I have linked a cell to a drop down list for the user to select the location
they are at. How do I show the text 'Select your location' in the cell as an
instruction to the user.
--
Thanks,

Kerri.

tim m

Adding a cell instruction for the user
 
You could click on the cell and then 'Insert'.....'comment' then type in what
you want to use for a prompt. When the person mouses over the cell your
comment should pop up.

"Kerri" wrote:

I have linked a cell to a drop down list for the user to select the location
they are at. How do I show the text 'Select your location' in the cell as an
instruction to the user.
--
Thanks,

Kerri.


Gary''s Student

Adding a cell instruction for the user
 
If the drop-down is by Data Validation, You can display Title and Message
when the cell is selected.
--
Gary''s Student
gsnu200707


"Kerri" wrote:

I have linked a cell to a drop down list for the user to select the location
they are at. How do I show the text 'Select your location' in the cell as an
instruction to the user.
--
Thanks,

Kerri.



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

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