Thread: Custom Keypad
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
EMoe[_56_] EMoe[_56_] is offline
external usenet poster
 
Posts: 1
Default 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