Hello,

I want to create a custom keypad using a userform with code.
The user form will have commandbuttons from 1 through 9. It will also
have a
button for :, AM, PM & Enter.

This box is designed to enter time into a specific cell.

Ex. The user will click 7 then : then 3 then 0 then PM, then click
Enter for 7:30PM.
I want to use this as a time saver. I will have this box pop up
whenever the
sheet is opened (I already have the code for the pop up).

Thanks for any assistance,
EMoe


--
EMoe
------------------------------------------------------------------------
EMoe's Profile: http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=472341

At its most basic, why not just place buttons and a text box (or label)
on the form to achieve this?

Alternatively, you could use the MS DTPicker control which you can set
as Time to allow the user to enter a time either through the mouse or
the keyboard..

My own preference is allow the user to type the time into a textbox e.g.
they type 0900 and I interpret this as 09:00 - but that's just because I
hate using a mouse for data entry.

HTH,
Gareth

EMoe wrote:
Hello,

I want to create a custom keypad using a userform with code.
The user form will have commandbuttons from 1 through 9. It will also
have a
button for :, AM, PM & Enter.

This box is designed to enter time into a specific cell.

Ex. The user will click 7 then : then 3 then 0 then PM, then click
Enter for 7:30PM.
I want to use this as a time saver. I will have this box pop up
whenever the
sheet is opened (I already have the code for the pop up).

Thanks for any assistance,
EMoe

Thanks Gareth for the reply.

I wanted to do something different with this type of data entry.
The way I need it set up is as I stated earlier; #1. because this pop
up box is part of a serious of other pop up boxes which the user is
using his/her mouse to make choices any way. #2. It would be easier for
users that isn't all so familiar with a keyboard (where is that darn
semi colon? :) ), to make a quick selection.

That's why if what I was asking was possible, it would have been
something different to try.

Thanks again... I'm still searching for a solution though.

Regards,
EMoe


--
EMoe
------------------------------------------------------------------------
EMoe's Profile: http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=472341

Would clicking a button on the popup menu that then shows a userform with
the time entry buttons be satisfactory?

--
Regards,
Tom Ogilvy

"EMoe" wrote in message
...

Thanks Gareth for the reply.

I wanted to do something different with this type of data entry.
The way I need it set up is as I stated earlier; #1. because this pop
up box is part of a serious of other pop up boxes which the user is
using his/her mouse to make choices any way. #2. It would be easier for
users that isn't all so familiar with a keyboard (where is that darn
semi colon? :) ), to make a quick selection.

That's why if what I was asking was possible, it would have been
something different to try.

Thanks again... I'm still searching for a solution though.

Regards,
EMoe


--
EMoe
------------------------------------------------------------------------
EMoe's Profile:
http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=472341

Yes! Let's see what you have.

Thanks, Tom


--
EMoe
------------------------------------------------------------------------
EMoe's Profile: http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=472341

I have attached a basic demo file. If you right click on any cell in
column 3 (C), you will have a time entry . . . option at the bottom of
the popup menu. Select that.

I haven't put in any checks for valid time values or anything. This is
just a demo.

--
Regards,
Tom Ogilvy


+-------------------------------------------------------------------+
|Filename: Timepad.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3873 |
+-------------------------------------------------------------------+

--
Tom Ogilvy
------------------------------------------------------------------------
Tom Ogilvy's Profile: http://www.excelforum.com/member.php...fo&userid=1960
View this thread: http://www.excelforum.com/showthread...hreadid=472341