How to Run an Event in MS Excel If a Cell Is Selected. Microsoft Excel runs events using Visual Basic for Applications, or VBA, a programming language for writing macros. Events often run in ...

Launch Visual Basic 6 or Visual Basic Express. Open the project file in which you want to create a module and command button that creates an Excel spreadsheet from selected data.

When you think VBA code is your only hope, try combing built-it conditional formatting tools. You might just find an easier solution than writing code.