user32

My hard drive crashed and now my macros will not work. I believe I need to go to Tools and References but what do I need to add for this line? Public Declare Function apiShowWindow Lib "user32" Alias "ShowWindow" (ByVal hwnd As Long, ByVal nCmdShow As Long) As Long I am running Windows 10 64...

I can't seem to get this to work. I'm wondering if there is a preference that I need to turn on or something, but not sure. Can anyone give me any help? Private Declare PtrSafe Function GetKeyState Lib "USER32" (ByVal nVKey As Long) As Integer I'm getting a Run-Time Error 453: Cannot find DLL...

When it crashes the error is highlighted on this line: Me.Caption = VBA.UCase$(Format$(VBA.Date, "yyyy - mmmm ")) & VBA.Day(VBA.Date) _ & " (" & VBA.Date & ")" I changed the declaration from this: Private Declare Function GetKeyState Lib "user32" (ByVal...

Good Afternoon, Been using the following code for years to clear the clipboard and it worked like a champ, until recently it won't work from a network drive or as an email attachment. This file works with both Excel 2010 and 2016 I get this error: Run-time error '435'...

this modified code from other Site the code below kill specific applications as you want and work well My problem with Excel Apps if this Work Book open next others Excel it kill it self while the hWndThis for SendMessage hWndThis, WM_SYSCOMMAND, SC_CLOSE, 0& belong for another one. Private...

Hello. I have a userform that when initialized textbox1.setfocus is run => all is ok I needed to remove the caption and x button from the userform => textbox1 will not get selected this is the code I used for the caption removal: in a module: Private Declare Function FindWindow Lib "User32"...

Hi! I've the following task: For about 80 people I've to create something that follows: - who is on break at the moment - who would like to go - notify a user if he/she can go to take a break, if the user can't react to this notification it should timeout (disappear) Unfortunately I have no...