Help: Macro works...But not on pressing button

Dear forum familie, (SOLVED, Thanks)

I'm working on a excel project and i'm a bit stuck.

I made a VBA script works fine if i call the macro from within the visual basic UI. But when i assign a button on that same macro it gives me a 400 error or it runs a part of it.

One button works fine tho, but why the errors on other buttons?

Anyone ever had such problem?


Hope you guys can help,

Mark

Below coding (not that it's necessary it works, only the buttons are doing weird...)

Please Login or Register  to view this content.

And the call functions

Please Login or Register  to view this content.

My guess, is that not all your objects are properly defined within context.

For an example. When you write Range("A1"). This refers to cell A1 of Active sheet.

If the sheet in question isn't active, you must qualify it with sheet name or sheet index (ex. Sheet1.Range("A1"))

Typically done by using With... End With and/or defining parent object variable.