keystroke

Hi All My first question. I use Excel, have programmed in Basic, have coded in machine code. I can sort of work out what is going on in a program but I don't know any of the instruction set of VBA. I have an Excel sheet that lists various products in one column. The user types in the number of...

I have an offset formula that is enclosed by { } Isn't there some kind of keystroke I have to hit to make it to work? Isnt the keystroke called "validating"?? The formula works perfect in another work book and I tried copying and pasting but it isnt copying. I then wrote the formula, changing...

Hi all, Been a while, I was looking at making my Training Database a little more use friendly. Currently anytime I would like to check on someones training I either chose one of two forms. I would like a field off to the right that every time I input a keystroke in it searches the table and...

I have a spreadsheet with two tabs; tab one is a keystroke calculator, tab two is an array of information. I want to be able to identify a skill class based on two values the Quality of Data and KPH values. Basically, if the value in "Keystroke Calc" C2 is "Handwritten and the KPH is between a...

I need quick help. Not sure if it's possible but I'm hoping it is. I have a loop in my code that increases the integer r by 1 with every loop. I want an IF statement within the loop in that if I press a key (eg "A"), r will increase by 1; so in that particular loop r will have increased by 2...

Hello, `Application.CommandBars("Workbook tabs").ShowPopup` gives me a dropdown list of sheet name if I chose one it will select that sheet I can run `Application.CommandBars("Workbook tabs").ShowPopup` from a button but is it possible to run from a keystroke? I am trying: Sub Auto_Open()...

For years on Windows 7, I would launch Excel by hitting the Windows button and then x. I'm now on Windows 10 and I can't figure out how to tweak windows to allow it. And instead of Excel launching, I now get Xbox launching, which I'd like to get rid of altogether. So, how can I make the...

Hi, I'm new to the forum. Thank you in advance for your help and sorry if I do not follow protocol (I am still learning). I am trying to build some macros in my own workbook to be able to improve efficiency to a protected workbook that can not be changed directly. I would like to: - While in...

I'm creating a "smart" search that will do a search after a user types anything in a cell. So whether it's two or three characters or several more, I want to call a macro. The outcome would be similar to the Google search page. Any ideas how to call a macros based on a user typing in a given...