key pressed event

  1. M

    Backspace for delete last letter on active part of userform

    Hi I want to use Backspace key to delete last letter typed on combobox2, but it show error "type mismatch" This is code for userform: Private Sub UserForm_Initialize() Me.ComboBox2.List = Worksheets("Sheet2").Range("B2:B600").Value Dim ws As Worksheet, rCell As Range, Key Dim Dic As...
  2. M

    Excel VBA - IE Automation Form Trouble

    I'm using Excel VBA to control IE - more specifically a javascript multi-page form with several text boxes and other elements such as drop down boxes. The drop-down boxes and multi-select boxes have an "onchange" event that I am successfully firing. And I am able to fill the text boxes out...
  3. F

    Enter Key = macro execution

    Hello guys, I'm new here! I've created an event key to run another macro. My macro does a search on the worksheet and returns values like monthly billing, store code, city and others. I write the criterion I want on A5:G5 and it returns on A6:G?? ... my problem is when I type text the macro...
  4. P

    Running macro on any key pressed event.

    Hi, Can anyone please advice me how to make a code so that it captures the event of pressing any key of the keyboard and triggers a macro. I tried using OnKey method but the problem with this is I am getting stick to any particular button whichever i specify in the onkey method wheareas I want...

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top