keyboard

I've seen this question & finally found an answer: "How do I interrupt code execution (Ctl + Break) if my keyboard doesn't have a 'Break' key?" My HP notebook has "pause" on the right Shift key. Fn + Right Shift = Break. Ctl + Fn + Right Shift = Ctl + Break ! Hope this helps. Has driven me...

I am building some shortcuts into excel and am wondering how do I make a keyboard shortcut that can toggle between different formats. I would like to create several toggles highlighted below and hopefully more thereafter: - Toggle Between Colors with “Cntrl + Shift + C” (Blue, Green, Red) -...

I have User form with one text Box in side, I change the window style of this User Form using " and Not WS_POPUP or WS_CHILD ". I want this User Form to be Child Window Style. After this process I can't type anything in textbox using keyboard. Please help!

Hello Everyone i am new here and have a question i cant seem to find a answer to. Ok so i have a spreadsheet that tracks labor for a company i work for and they have provided bar codes to employees for there badge ids but they also have bar codes for activities that they choose not to use and...

Hi all, I was typing along normally when suddenly my keyboard started typing the wrong characters. This is happening ONLY in Excel. I'm working with Excel 2010 on a Windows 7 machine. I may have fat-fingered something at the lower left of the keyboard (CTRL, SHIFT, ALT, Caps Lock and Windows...

Hi all, I am using Excel for Mac 2011 and when I am trying to edit a formula in a cell and reference another cell, I hit ctrl + tab to switch workbooks and when I do it cancels the edit formula. When I click on the second workbook while editing a formula it works fine. Is there any solution to...

I thought that setting ScreenUpdating and EnableEvents equal to false while executing code would disable all keyboard and mouse events while code is executing, but I was surprised to see that that was not the case. I have created a simple example that takes a few seconds to execute. While it...

Good morning everyone, As with several other posts on here I am a relative novice on codes and such like so please keep n replies really really simple! I wish to set a particular cell on spreadsheet (Windows 7) to accept only scanned from barcode data. Is it possible to protect cell to ensure...

Hi. I'm scrapping some conditional formatting. Selection.FormatConditions.Add Type:=xlExpression, Formula1:="=AND(NOT(ISBLANK($AG3)),LEN($AG3)>12,Colors_On=TRUE)" Code works just fine until found a coworkers that uses international / French keyboard and I found that "," needs to be ";" to...

When I start to type a formula Excel helpfully provides a dropdown list of matching functions. e.g. Type "=ave" in a cell and Excel provides : AVEDEV,AVERAGE,AVERAGEA,etc Is there a way to select an item from the list without touching the mouse? I can use the keyboard up/down arrows to...

Hi to all, I am trying create an automatic counter for our Complete blood cell count. I have something in mind using COUNTIF. However, I would like to know if someone have any idea how to manipulate the keyboard function and characteristic to where when a user select and press a letter in the...

Heyyyya folks! Been a while since I've been here, but I've been trying to find some information and not having any luck, so....here I be! :) I'm one of those people who loves keyboard shortcuts more than using the mouse, as a general rule. I use the Text to Column function on a regular...

I have the following script for a couple of VK keys for keyboard event but need the following keys also, can someone please help. Private Declare Sub keybd_event Lib "user32" ( _ ByVal bVk As Byte, _ ByVal bScan As Byte, _ ByVal dwFlags As Long, _ ByVal dwExtraInfo As Long) Private Const...

Dear Anyone, I'm sure this question has been asked a million times, but I can't find it under keywords "Mac Shortcuts" here and astonishingly can't find anything under a Google search. Would anyone happen to have a list of the Excel keyboard shortcuts for a mac? There are a host of "hotkey"...

Hi All, Quick question; I know that with the ALT+Down Arrow you can open a drop-down list, and by hitting the first letter of the entry you're looking for you'll navigate easily to that entry. But what if you've got loads of entries starting with the same letter; is it possible somehow to...

Hello: I've searched everywhere and haven't been able to find anyone else who has had this issue. I have a workbook that runs some auto_open code whenever the sheet is opened. This code is fairly short and simple. About 20% of the time, this code activates my keyboard/mouse switcher and causes...

Hello all In a previous version of Excel (or with the help of an add-in or macro) it was possible to hit the ENTER key (after selection of a a cell that contains a hyperlink), on which Excel did follow that link (to a cell, sheet, file, internet, whatever). I cannot find this "function" in...

"Huh?! Chinese?! I don't even speak Chinese!!! Well, we'll just pop into the old regional settings and get this taken care of!" And thus began a rather frustrating quick and dirty scouring of the internet. I had just bought a new notebook and was running Vista. I'd hopped into Excel for the...

all of my googling and help searching has come up empty on what I thought would be a simple search. I just want to find the keyboard shortcut to change the active tab in Access 2007. You know like what Ctrl+Page Up (or Down) does in Excel or Ctrl+Tab in IE Does anyone know how to do this?

Hi, I use the CTRL+SHIFT+$ Currency shortcut often. Recently it's won't format the cell correctly (it only has 1 decimal place & the negative numbers aren't turning red). Below is an example of what I mean: 14500.32 CTRL+SHIFT+$ returns- $14,500.3 -14500.32 CTRL+SHIFT+$ returns-...