Tuesday, February 7, 2017

How do I run a VBA function in Excel?

I want to run this function


I opened the developer tab in excel, no clue what to do now. I tried creating a "macro button", and then paste the function code in the macro script, but if I press play I get a error related to Private Sub CommandButton1_Click()


and if i try to save the macro, I get this dialog box:


enter image description here

-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

hard drive - Leaving bad sectors in unformatted partition?

Laptop was acting really weird, and copy and seek times were really slow, so I decided to scan the hard drive surface. I have a couple hundr...