Posts by Wilker12

I found out: SetWindowsHookEx, UnhookWindowsHookEx and CopyMemory!

citopo, tnx!

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

Tnx.

Ok. How would I do a "commandbar listener"? Thank you.

Thanks for the question, rory.

I have projects that need several constants loaded so that all requests while using the sheet are executed more quickly.

However, sometimes I need to change something in the VBA code, and after I do that it resets the project. And then all the constants are emptied, requiring several calculations and checks to be done to reload them.

I wanted the routine to load the constants to be re-executed as soon as I left the desing mode, understand?

If "Sub Worksheet_Activate()" worked when I left desing mode, it would do. But, the Activate only works if after the design mode I click on another sheet and then go back to the one that has the Activate.

Hello,

Is there an event that is triggered at the exact moment I exit Design Mode?

I looked for something like "Sub DesignMode_Deactivate()" in the events in the workbook list, but I couldn't find it...

Thanks.

I found: Var1 = ThisWorkbook.VBProject.VBComponents().CodeModule.Lines()

Hello!

How to copy a class's VBA source code to a variable?

I don't know if there would be a command like this: Var1 = Sheets("Sheet1").VBACode

Thanks.

Yes, royUK, but I don't think it is impossible to unlock...

Do you know how to save a .xls file to .pdf using PHP commands?

Thank you!

Hello,

Is it possible to put my client's spreadsheet on my website, so that he can use it over the Internet without viewing the formulas?

Thanks.

Yes, royUK, exactly! It was the only thing that solved it. I found this solution a few minutes ago, a tutorial explaining that "there’s a bit of a bug" in my version of Windows ( https://wellsr.com/vba/2015/tu…to-clipboard-paste-clear/ ). Thank's, success!

Hello,

I have tried in several ways to simply copy text to the clipboard, but I can only make the content viewable within Excel itself. Notepad returns empty and Word returns two unrecognizable characters. What could be happening? Is there another alternative? (by API only found to clean)

Dim Object_ As MSForms.DataObject
Set Object_ = New DataObject
Object_.SetText "Text", 1
Object_.PutInClipboard
Object_.GetFromClipboard
Range("A1") = Object_.GetText(1) 'works perfectly, but only within Excel

Thank you, Wilker.

Interesting! Ok, thank you.