"Microsoft® Excel® for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20124) 64-bit"
Posts by Wilker12
-
-
...the last two buttons in the example, no.
-
...I had already noticed that you used 0 and I used variations, but it didn't change the result here. Tnx.
-
-
Within the context I mentioned, no, rory. But, grateful.
-
Hello,
I noticed two bugs in Label. I reproduced the isolated statement in a new project and the error repeated. There are two situations in which Label always recognizes a False value as True:1- If it comes preceded by an Intersect
Var = Intersect(Range("A1"), Range("B1")) Is Nothing
Label1.Font.Underline = False
2- If it is in an OLEObjects and With
With OLEObjects("Label1").Object
.Font.Underline = False
End WithIf anyone has a solution, thanks!
-
BisonPup, I had already tried DoEvents. Tnx.
-
Hello,
I noticed that VBA only immediately shows or hides the status bar through the if there are few instructions within the sub or function. Otherwise, it only executes the show or hide order at the end of the routine. Is there any API that shows or hides the status bar?
Tnx. -
-
Hi cinziorecoaro, My code has the same problem in the line "CopyMemory VarPtr(uParamStruct), lParam, LenB(uParamStruct)" for the same reason. How did you solve it? Thanks.
Quote"We had several 32-bit versions of Excel from 2003 to 2016 and Excel 2010 64-bit. Everything worked perfectly until we have updated the computer with Office 2016 64-bit: the mouse wheel scroll works for a few seconds then inevitably the application crashes and restarts. If I disable the use of the wheel application works perfectly but we would like to use it."
-
I found out: SetWindowsHookEx, UnhookWindowsHookEx and CopyMemory!
-
-
S O, I have a routine that displays to the user with a full screen (form) only the image he chose. The routine should enlarge and reduce the image on the form according to which the user only controls the mouse roller, in the same way as on Google Maps. That's why I need to capture mouse roller data. What API can I use? Thank you.
-
Hello,
Does anyone know a way to capture every time the mouse roller (scroll wheel) is used on a form? ChatGPT and Bard indicate the "Form_MouseWheel" sub. But, there is no such sub in Excel. Through Google I saw that it exists in Access.
Thanks, Wilker.
-
Rory, perfect. Tnx
-
Hi Carim,
I did not find in the hierarchy of the VBIDE library any class, property or method referring to the values in the Format Editor.
But, thankful.
-
Yes. But, when I need to access Excel on another computers, I have to configure item by item again...
-
Hello,
Is there a way to export the settings in the "Editor Format"? (Tools > Options > Editor Format).
Some button or algorithm that saves to file and can be imported into another Excel.
Thanks
-
-
Ok. How would I do a "commandbar listener"? Thank you.