Results 1 to 3 of 3

Thread: problem with SENDKEYS capslock

Threaded View

  1. Jun 11th, 2005, 01:25 AM #1
    tonyelyn
    tonyelyn is offline

    Thread Starter
    New Member
    Join Date
    Mar 2005
    Posts
    6

    Resolved problem with SENDKEYS capslock

    I'm having a few unprotected cells on a EXCELL worksheet. The user has to type in some text, but in capital letters. I hoped at the same moment of opening the file, a SENDKEYS capslock would help. I tried to type in

    SENDKEYS "{CAPSLOCK}"

    in my code and/or in the immidiate window of the visual basic editor. No warning messages, but nothing changed.
    Can somebody help me or give me a better way to prevent the user to use small letters.
    Last edited by tonyelyn; Jun 11th, 2005 at 01:12 PM. Reason: Problem solved
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width