Multiple cell address inputs to a macro

Dave

this macro uses the worksheet change event to trigger the macro.
When you select your checkbox and it updates the entry in column B this macro will change cell colours as required.

The macro goes in the Worksheet module sheet not the normal module sheet

Please Login or Register  to view this content.

Thanks for responding, Mudraker. I'm sorry though, I don't know the difference between a worksheet module sheet and a normal module sheet. When I select a sheet from the tree and right click, I can insert a module, but it doesn't show up under the sheet in the tree. It shows up and an additional project module. Can you tell me the difference and how to build a worksheet module sheet?

Dave

Dave

A worksheet module is created automatically for every sheet that is in your workbook. There is also a workbook module

From the Visual Basic Editor you should have a Project - VBA Project Window that lists your normal module sheets, forms etc. You will also have kistings of Sheet1 (Your Sheet Name As Seen In Excel) - This is the Worksheet Module. -
Use Ctrl + R to open Project Window or View Menu

Another way to get to the worksheet module is from Excel >Right Click on Sheet Name Tab > Select View Code.

The workbook and Worksheet modules allow for macros that are triggered to run automatically by events occuring in the workbook or worksheet.

To see these event trigers from the Worksheet module change the Left drop down list from General to Worksheet - The Right Dropdown list will then have a list of available Trigger events.
For worksheets the events only effect the one sheet that the macro is on.

You can not call a macro on a Workbook or Worksheet Module without using the full module sheet name unless the calling macro is on the same sheet.

The Private Sub Worksheet_Change macro needs to go on the Worksheet Module for the sheet that has all your check boxes.

When you Check or Uncheck a check box that updates rows in Column B triggers the Worksheet Change macro.

This macro checks if the change was to a cell in column B if it is it then sets cell colur based on if it has a true value or some other value.

It is possible to have code within the maco that updates the sheet that will cause the macro to re triggered which is why used Application.EnableEvents = False. If the macro stops running before it gets to Application.EnableEvents = True no future event changes will trigger the macro.

If this is occuring place Application.EnableEvents = False in another macro on the same sheet and run it manually