I need a userform that would help me in entering Time in a worksheet cells.
(Something like i click on a cell then a userform would pop out that help in filling in time in cells rather than filling in times manually)
Thanks in advance
I need a userform that would help me in entering Time in a worksheet cells.
(Something like i click on a cell then a userform would pop out that help in filling in time in cells rather than filling in times manually)
Thanks in advance
Last edited by dollar; 08-11-2009 at 01:53 PM.
Could you be more precise/explicit in what you mean?
Exactly how does entering time into a userform differ from entering into a cell on the worksheet?
Are you wanting to be automatically entered in the cell? What time values? Or do you just want to make sure time is entered in a specific format?
Here's an example using combo boxes. You need to decide how to load the form, maybe use a selection_change event
Combo_Time.zip
Last edited by royUK; 08-17-2009 at 03:20 AM.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
i am not able to open the linked page
I've fixed the link
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks