pressed

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...

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...

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...

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

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?

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...

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...

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...

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...

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...

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...

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...

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...

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"))...

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...

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...

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...

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?

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...

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