how to call avba function on an excel sheet

February 5, 2012 at 22:02:32
Specs: Windows XP
how do I call a vba function on an excel sheet? I got a vba script to sort cells by color format, I don't know how to "call" the script on my spreadsheet. Any helpful info is greatly appreciated.

See More: how to call avba function on an excel sheet

Report •

February 6, 2012 at 08:22:39
You can create a button specific to the worksheet in question and then assign the macro to it.

You can set it up so that a change to specific cell or cells causes the macro to run automatically.

You can create a tool bar button that will make the macro available in any and all workbooks.

You can...well there's lots of other things you can do to "call" the macro from within a spreadsheet.

If you'll provide some details, we can make a more specific suggestion.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question