Userform menu will use on 32 bit and on 64 bit

[ivayleto]

Hello, can somone help me to run this userform menu to start on 32 and on 64 bit (excel vba). I try with convert but I wrong and dont know where. Can you give me advaice what I change? Thank you

menu maker

 

[ISY]

Hi

Public Declare PtrSafe Function SetWindowLong _
    Lib "user32" _
        Alias "SetWindowLongA" ( _
            ByVal hwnd As LongPtr, _
            ByVal nIndex As LongPtr, _
            ByVal dwNewLong As LongPtr) _
As Long

 

[ivayleto]

Hi

Public Declare PtrSafe Function SetWindowLong _
    Lib "user32" _
        Alias "SetWindowLongA" ( _
            ByVal hwnd As LongPtr, _
            ByVal nIndex As LongPtr, _
            ByVal dwNewLong As LongPtr) _
As Long

but now Routines not worke. when i clic on menu not hing happen. Any idea?

 

[ISY]

Hi

I have changed the code and it works as expected Excel 365 64 Bit

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

How this macros can run on 64 and on 32 bit office

Hello can you somone tell me how make this macros to run on 32 bit and on 64 bit Office? on 32 bit macros is run but on 64 bit it not and it is in red color. Thank you. Public Declare Function

stackoverflow.com

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[ivayleto]

Hi

I have changed the code and it works as expected Excel 365 64 Bit

Thanks for help. Only one changes you make. Because when I click on "Show Api Menu" - userfom is appear, but whet I choose any of menus ex: File->NewTask nothing happen. Can you try you that will happen when you clicked. Thank you!

 

[AI_Programming]

Hi @ivayleto , there's any chance for me. to get the file with the solution of this thread. please!!