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

listi.net

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.