Hi,
How do I have a cell show instructions in it until the user enters data into it? I want the cell to say "Mileage", then the user will click on it and enter a number for the miles that will be travelled. The "mileage" text will disappear and will obviously show the number they entered.
Thanks!
Hi, you'll probably have a good reason for asking this ...
But you can just format the cell as number and type the word Mileage in it.
A user selects the cell en enters the mileage, done.
You must however realize that if you have formula that includes this cell to add the value, it will return an error until the user enter a number
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
I was confused as well...Originally Posted by Keebellah
Hi, you'll probably have a good reason for asking this ...
OP, you could also use Data Validation. With an input message, a text box (with a title and body option) will appear on screen when a given cell is selected.
Hi Guys, I realize I come across as kinda stupid asking this question without the right context... Obviously if you just type in Mileage this will work, and If i click that cell and type "370" it will show that and not "mileage"...
I should've specified I guess: I want the word "mileage" to come back up if I delete the "370"...
I've seen other posts about Data Validation. It would technically accomplish what I am looking for, I just like the way the other solution looks (how I imagine it in my head at least). In the end, I might just use Data Validation but I thought I would try to find something else first.
Thanks!
Well, you ask and you get a way to do it.
if no mileage is entered enter a 0 (that's the way it'now
Enter your mileage in the cell 'Mileage'
I used the custom number format 0,00;;"Mileage"
No, no, no; we weren't insinuating you sounded stupid; we were just confused over what exactly what you were asking for. It's clear now!
Who knows, someone may have a solve for exactly what you're wanting (not me,) but if not, I think the Data Validation will achieve the same goal (if less aesthetically appealing.)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks