numlock

  1. C

    One or more Modules for each sub

    I am wondering I have one module with 95%+ of the code for my macro in different subs. what is the cleanest way to do this? Each sub in its own module? also is it better to put all the code that is for just that sheet in a module attached to a sheet? Or other ideas that may help? all my code is...
  2. C

    IE printscreen Call keybd_event(VK_SNAPSHOT, 1, 0, 0) turning NumLock off

    Sub IE_Load_PrintScreen() ' IE and OutLook Dim NorryLink As String ' Link to copy Print Screen NorryLink = "Home - County of Northumberland" & Sheets("Tax Cert Bill").Range("B17").Value Dim IE As Object Dim hwnd As Long, IECaption As String Set IE =...
  3. Johnny C

    Get worksheet_Change event to run in any worksheet in any workbook

    Hi We have to use an Add-In to access Sun Financials from Excel (Infor Q&A). It's locked so I can't see inside the VBA, but I'm guessing it uses SendKeys as when you use it from a virtual desktop box (Wyse terminal type thing) it randomly turns NumLock off. Which is a big pain. It retrieves...
  4. E

    VBA - Edit Mode & Go to Start of Cell without SendKeys

    In VBA, I would like to enter the Edit mode of a selected cell, and move the cursor to the start of the cell. Via the keyboard, this is accomplished by F2 & Ctrl+Home, and I have been using this code: SendKeys ("{F2}^{HOME}"), True SendKeys is causing a NumLock toggle issue :eeek:, and the...
  5. P

    Name_Slug issue on change from 97 to 2003

    This is my first post ever anywhere on this subject and this site. I am a noob. My Office database was created by an employee a while back. I've taught myself things by trial and error repeating things I see he did, such as adding fields and duplicating code lines to address the new fields. So I...

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