Need more address to be able to trigged from - see code below

**cagney1** · 10-30-2015, 10:31 AM

I think I found this code on the forum but have a question.
In the code below I would like to know how to have more than one target address to trigger other marcos.
I have approx. 110 more addresses that I would like to trigger from each with their own set of macros to run if possible.
BTW they are not all in column G. Thanks for your help in advance.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$G$21" Then Exit Sub
If Target <> "" Then
Select Case Target.Value
Case "-"
Call Macro2

Case "&", "D", "R", "+"
Call Macro3
End Select
End If

End Sub

**skywriter** · 10-30-2015, 11:44 AM

Without you sharing the workbook with the addresses, I would suggest that you have to create a named range that has these addresses in it, then use intersect in your code to check if the target that changed is part of your named range. There are probably other ways to do it, but without seeing the workbook, or knowing the addresses, it's hard to tell you how to do it.

**cagney1** · 11-02-2015, 10:44 AM

I have attached the sheet and macros that I have been working on. I am sure that their is a better way to do what I am trying to do I just don't know how to do it.

I am trying to run the macros for every room so that as I change the data in cell G21, for example, it will change the other cells in columns G & H that need to be changed. If I change the data in cell I21 it will change the data in cells in columns I & J as needed.

**skywriter** · 11-02-2015, 12:13 PM

I am trying to run the macros for every room so that as I change the data in cell G21, for example, it will change the other cells in columns G & H that need to be changed. If I change the data in cell I21 it will change the data in cells in columns I & J as needed.

Are you going to give details as to what should happen?

Need more address to be able to trigged from - see code below

LinkBack

Thread Tools

Rate This Thread

Display

Need more address to be able to trigged from - see code below

Re: Need more address to be able to trigged from - see code below

Re: Need more address to be able to trigged from - see code below

Re: Need more address to be able to trigged from - see code below

Thread Information

Users Browsing this Thread

Similar Threads

Code to search for address via Name

How to get a Zip Code from an address

Need VBA to look up for ZIP code in address column.

[SOLVED] Separate Zip Code from Address

Email selected print section to address located in a cell instead of email address in code

Extracting Zip Code from Address String

How do I put the zip code in the address label?

Bookmarks

Bookmarks

Posting Permissions