Results 1 to 1 of 1

Thread: [Resolved] User Form (Excel) and a control + delete key

  1. #1

    Thread Starter
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    [Resolved] User Form (Excel) and a control + delete key

    Hi,

    In excel I have a user form, tempting fate that the excel application won't run out of memory for all my code and the form itself.

    I have a couple of lists on the form, so I thought wouldn't it be nice if the user pressed delete after selecting multiple items in a list, that those items were removed/deleted.

    So I have two buttons that work to add and remove items, but the key press on the control (lstTotals_KeyPressed) won't return the delete key, it does the backspace, and buttons on the keyboard, but not delete.

    Any ideas as to why or how to get around it??
    I'm going to try keydown next and see whether that works.


    Vince

    <edit>
    Key press.. nono
    Key down does it, perfectly
    </edit>
    Last edited by Ecniv; Jun 24th, 2004 at 03:10 AM.

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...

Posting Permissions

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



Click Here to Expand Forum to Full Width