Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Drop Down Box to Choose Time
How do I create a Drop down box to choose the time and enter it into a cell,
instead of typing it in. thanks. -- Jeff |
#2
|
|||
|
|||
You don't say what times you want to put in. You could do this with a
drop-down from the forms toolbar, linking it to a range with your time data in If it's simply the current time you could just type Ctrl+Shift+: -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "GoBucks" (DoNotSpam) wrote in message ... How do I create a Drop down box to choose the time and enter it into a cell, instead of typing it in. thanks. -- Jeff |
#3
|
|||
|
|||
GoBucks...
Use Data validation. What I do with this is: On a seprate sheet ( or someplace out of the way) place =NOW(), and format for time. With the cell still highlited goto the name box (upper left corner of worksheet) name the cell (ie "Time") be sure to hit "enter" to get out of the name box. Now, select the cell that you want the time to be placed and goto data validation, under "allow" select "list", select "source" hit f3 and select the name that you used to name your range that had the Now(). In the source box you should now have ="Named Range" (without the " "). Be sure that "in-cell dropdown" is checked. Ok out and you are done. Remeber though that once you place a time in this cell and save it, it will stay that time when you open it the next time, it does not update! Mike Rogers HTH "GoBucks" wrote: How do I create a Drop down box to choose the time and enter it into a cell, instead of typing it in. thanks. -- Jeff |
#4
|
|||
|
|||
Hey guys, thanks a million for the replies.. What i am trying to accomplish,
is to make a form where the user can choose a time for patient admission/discharge, this could be future, or past. I wanted to let them enter the time from a drop down box so they do not have to type it in. I created a list for the hours, and minutes, and am/pm, but i figure this would require 3 seperate cells/drop downs for each list. I was looking for something relative to the calendar pop-up... wishful thinking? -- Jeff "Mike R" wrote: GoBucks... Use Data validation. What I do with this is: On a seprate sheet ( or someplace out of the way) place =NOW(), and format for time. With the cell still highlited goto the name box (upper left corner of worksheet) name the cell (ie "Time") be sure to hit "enter" to get out of the name box. Now, select the cell that you want the time to be placed and goto data validation, under "allow" select "list", select "source" hit f3 and select the name that you used to name your range that had the Now(). In the source box you should now have ="Named Range" (without the " "). Be sure that "in-cell dropdown" is checked. Ok out and you are done. Remeber though that once you place a time in this cell and save it, it will stay that time when you open it the next time, it does not update! Mike Rogers HTH "GoBucks" wrote: How do I create a Drop down box to choose the time and enter it into a cell, instead of typing it in. thanks. -- Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert A drop down dialog box as a 'list to choose from'? | Excel Worksheet Functions | |||
How do I choose multiple values in a drop down box? | Excel Discussion (Misc queries) | |||
How do I choose multiple values in an excel drop down box? | Excel Discussion (Misc queries) | |||
Drop time in date/time field | Excel Worksheet Functions | |||
unmet challenge | Excel Worksheet Functions |