By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step 754 - Click a button

One way to allow a user to interact with VBA is to add Buttons to a sheet that perform some function.

There are 2 types of buttons you might run into.

Form Button

ActiveX button

I prefer using the Form Buttons because the ActiveX button do weird things when working remotely.