RE: Send Keys
- From: "bigwheel" <bigwheel@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 6 Aug 2005 18:03:13 -0700
The syntax you need to use is:-
Application.SendKeys("{CAPSLOCK}")
but I can't get that to work either. Why not allow users to type their data
into the user form and then use the UCase function to change it?
"Sgwapt" wrote:
> Hello All,
>
> I have used the SendKeys method but having trouble with this one.
> When a user form is initialized I would like to check if the CapsLock key is
> on and then if not turn it on so users entries are consistent with text
> strings. I know how to add the if but the key method is not working
>
> Here are 2 examples I tried;
> SendKeys CAPSLOCK
> SendKeys = {CAPSLOCK}
>
> What am I doing wrong?
>
> Thanks
> --
> George G
.
- References:
- Send Keys
- From: Sgwapt
- Send Keys
- Prev by Date: Moving a Variant to Array
- Next by Date: Re: colorindex = xlnone on condition of month of year
- Previous by thread: Send Keys
- Next by thread: Personal workbook opens and messes up workbooks(i)
- Index(es):
Relevant Pages
|
