Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am designing a User Form to allow someone to enter their name. There is no
keyboard only a mouse for input. I have the alphabet represented by using Label Objects. Each lable has the appropriate caption A,B C etc. I use the SendKeys method to enter letters in the Text Box when the appropriate lable is clicked. Example: Private Sub Label3_Click() SendKeys ("b") End Sub I also have a lable to set capslock: Private Sub Label2_Click() SendKeys ("{CAPSLOCK}") End Sub I would like the caption on each all of the letter labels to change with the state of Capslock. In other words when CapsLock is on the label would read "A" and when CapsLock is off the lable would read "a" etc. for all the letters. I'm sure there's a way to do this using the vbKeyCapital constant but I don't know how. -- Bernie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
user form input | Excel Programming | |||
VBA Question: User Form and input masks | Excel Programming | |||
VBA Question: User Form and input masks | Excel Programming | |||
User Input Form | Excel Programming | |||
Help with a User Input Form | Excel Programming |