locked
Code Window Asscioated with Sheets? RRS feed

  • Question

  • I'm new to VBA and have a very basic question.  In the project tree on the left, the sheets on my workbook are show.  If I double click on one, what appears to be a blank code window appears.  What is this for?  Why would I write code in here as opposed to a Module or a Class Module? Thanks!

    Tuesday, July 2, 2013 12:20 PM

Answers

  • That module is for event code, associated with the sheet. In the left hand drop down above that module, select "Worksheet", then in the right-hand drop down all the available events will be listed.
    • Marked as answer by Dummy yoyo Tuesday, July 9, 2013 9:22 AM
    Tuesday, July 2, 2013 1:59 PM