pressed

  1. TAPS_MikeDion

    MS Excel for Mac 2011 - VB Ver 14.0 - Escape Key capture

    Hi all, Does anyone know if VB key capture works with Excel for Mac 2011? I have tried several different methods to capture the ESC key being pressed and I can't seem to get it to do anything. The last simple thing I tried was: Application.OnKey "{ESC}", "EscapeKeyPressed" inside the...
  2. G

    How do I run a macro every time key pressed

    Hi I found this macro on here that runs a macro when the delete key is pressed on book opening. What I’m trying to do if poss is to have this but to be able to have it numerous times. I.E click on delete key run macro then push delete key run another macro and so on.... Can I do this...
  3. Y

    How to get into that edit mode?

    In edit mode, when one letter is highlighted and left or right arrow key is pressed, usually, no letter is highlighted anymore. However, recently, I highlighted a letter, pressed an arrow key, and the next letter was highlighted. This is quite handy if I need to replace several letters in a...
  4. M

    Prevent Selection Change

    Hi I want to prevent the SelectionChange procedure from running if the user pressed the TAB or RETURN key to get to the cell. How do I check for the last key pressed ? Thank you in advance. Al
  5. D

    if no formula in a cell

    When a button is pressed, if there is no formula in a given cell, I want to put a formula in a the cell. What is the vba for this?
  6. J

    Best way to use a macro to insert new rows

    I have a workbook that has data in range A5:J54. Sometimes a row will need to be added if that range is full but only for columns A:J. I'm not sure if its best to have a button that just inserts a new row every time its pressed below the last entry in that row or to have a button that when...
  7. A

    Waiting command button

    Just wondering how others may get around this. My form processes a pile of data, comparing various values. If it finds a difference then display it and wait for the user to click a "Continue" button. But I don't want a msgbox. What else does the same job? Ideally just a button that waits to be...
  8. S

    VBA/Macro Button Password Protection

    Hi All, I developed a tool for employees in different dept. and the tools automatically captures data filled and send it to the tables (Which i created in different tabs, which are hidden from the employees). After that comes a validation tab where only managers are allowed to see it. The...
  9. O

    Formula to output Column No. after Enter is pressed?

    Hey everyone, What formula can give me the column number of where the enter key has been pressed after editing the cell's value. My workbook is set on automatic calculations. Please note that the formula will be residing in the sheet named = Hosting , whereas it should be detecting the Enter...
  10. O

    Creating an Excel Stopwatch..

    Hey all, I would like some help on creating a stopwatch that works every time a key is pressed and stops every time the same key is released. A pop up that should let the user know for how long the key was pressed for. This should work for any key. eg format for the pop up window The key...
  11. J

    VBA - Combining IF and Hidden rows

    Hello Everyone, Ive built a Spreadsheet which will reveal some rows (which contain notes) once a button is pressed. It will then hide the rows once another row is pressed. Below is a simplified version of the sheet. So once we press the 'Show Notes' button above it will run the simple macro...
  12. A

    Time Tracker For Team Members

    Hi, I am looking for a login and logout time tracker for my team. Below is what i have in my mind any better ideas are much appreciated. 1.When User Enter the Employee ID in Sheet 1 Page, it should fetch the name from "Sheet 2"(Data). More people will be added later 2. When LOGIN Button is...
  13. J

    Problem running macro when cell value changes due to option box selection

    Hello all, I've got two option buttons that are linked to cell V1, giving a 1 or 2 depending on which button is pressed. If the top button is pressed the I want to hide Chart 2. If the bottom button is pressed the I want to show Chart 2. ChartOnOff works perfectly if I manually run it but...
  14. K

    VBA upress toggle button in ribbon (ui)

    Hi, After hours of readings and tries, I don't get how to change the value of a toggle button to false (not pressed) with VBA. Sub TbtnManClick(control As IRibbonControl, Pressed As Boolean) Dim Manvalue As Variant Manvalue = InputBox(Range("LgMan"), Range("LgMan"), Range("RngMan"))...
  15. M

    Macro to confine cursor to set boundaries

    Hello, Is it possible by vba to restrict the mouse movements to a given area of the screen. Ideally, I would like the cursor to be confined to a large button area once the button is pressed and triggers a macro, but by pressing esc or a similar key regain free movement, but then be confined to...
  16. J

    Macro/VBA: Complete Newbie trying to Record a Macro

    A complete newbie here trying to record a Macro to an arduous task. I collect information each month and then have to sort the Data by highest value. Starting in Column L I have a product name, then in Column M the sales for the month. Each month I go in highlight the data in Columns L and M and...
  17. R

    Change ribbon toggle button state

    Hello I have a toggle button added to the ribbon (xml way) and I have the following code: Sub ribbonbutton1(control As IRibbonControl, ByRef cancelDefault) If Sheets("Database").Range("I2") = "Yes" Then 'check if master If Sheets("Database").Range("I4") <> "Yes" Then...
  18. D

    VBA UI Ribbon Toggle Button

    Hi, I have created a toggle button in xml which works ok but what I would like to do is enable two other buttons on the ribbon If toggle button is pressed and disable the same two buttons when toggle is un pressed. Can some one help with this please?
  19. F

    ttt

    Hello, unfortunately it is not possible to upload a file, so I try to explain it as best as I can: I use =NORM.INV to produce columns of random values like: <tbody> Values Values Values Values Values Values Values Values Values Values 26.8538815 5.45631173 -51.0077324 79.4960151 39.7611752...
  20. N

    VBA code to Record all keys pressed in window

    Hi all, Could you please provide me a macro that record all keys pressed in anywhere in system. It will also fine if it record all key pressed in Internet explorer only. Thanks, Nitesh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top