Form control- button with updated date.

[johannordgren]

Hello there,

Need help with a VBA code or a macro for a clickable button.

When the button is clicked I would like "the text in the button" to update the days date.

Thank you!

 

[dmt32]

I suppose. I only have one "Sheet". And I open VB from "view code" by right-clicking on the button.
If this is what you mean with "Activesheet".

Yes I thought you may be running the code other than clicking the button which may produce the error you have if sheet button resides is not active.

As already mentioned, right click the button and select assign macro should resolve issue.

Dave

 

[johannordgren]

If you're willing to take another shot with mine, you can right click the button and use "assign macro" then make sure the Button1_click is actually selected.

For the record, I'm having success with my code and Dave's code (though my 'merican date format doesn't match Dave's) :P

Okey, now this worked tho. I was using an ActiveX button. Maybe that has been the entire problem?

Since I changed to a Form control button now..

 

[dmt32]

Okey, now this worked tho. I was using an ActiveX button. Maybe that has been the entire problem?

Since I changed to a Form control button now..

would have been helpful if mentioned that from outset but no worries so long as resolved.

Dave