1. B

    Keyboard Shortcut to Toggle between Various Formats (e.g. font & fill color, numbering)

    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) -...
  2. K

    Can't type in textBox using Keyboard

    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!
  3. D

    VBA to Disable keyboard entry but allow Scanning entry from Motorola DS9808

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

    Keyboard Is Typing Wrong Characters ONLY In Excel

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

    Excel Mac 2011 Ctrl + Tab while editing formula cancels editing window

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

    Disable Mouse and Keyboard events while executing a macro

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

    barcode scan only

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

    Adding formulas by VBA; dealing with international keyboard differences

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

    Excel 2007 - dropdown lists - keyboard/mouse frustration!

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

    Dynamic counter for counting human blood cell

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

    Fixed-width Text to Columns without using mouse?

    Heyyyya folks! Been a while since I've been here, but I've been trying to find some information and not having any luck, 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...
  12. J

    Key Event VK Keys

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

    Mac Shortcuts for Excel

    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"...
  14. M

    Excel Drop-down list keyboard shortcut

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

    Keyboard/mouse switcher issue when using VBA

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

    How to follow hyperlink with keyboard?

    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...
  17. Greg Truby

    Is your Ctrl+Space keystroke is gettin' jacked to Chinese?

    "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...
  18. J

    What is the keyboard shortcut to change tabs in access 2007?

    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?
  19. J

    CTRL+SHIFT+$ keyboard shortcut not working

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

    Scroll lock key

    Let me start off by explaining what I am trying to do. I would like the scroll lock key to light up whenever there is something in my range and turn off when it is empty. I have the procedure below called every minute (I'm using Application.OnTime to do this). It is a small part of a much...

Some videos you may like

This Week's Hot Topics