Custom Keypad
 

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

Custom Keypad
 

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

Custom Keypad
 

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

Custom Keypad
 

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

Custom Keypad
 

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

Custom Keypad
 

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

Custom Keypad
 

Tom, you hit the nail on the head, and countersunk it.

This is perfect! Exactly what I was looking for. :)

Thanks for all your help.

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