If Target address method with range of cells

**Gti182** · 05-15-2017, 05:52 AM

Hi all,

Looking to run a macro when any cell is changed in range D3:D5 via drop-down box. Currently the cells are set to "select" as default text but the user has the option of choosing choosing a value from 1 - 10.

test file attached.

thinking the code to go something like this

Please Login or Register  to view this content.

**sintek** · 05-15-2017, 06:05 AM

Can try this:

Please Login or Register  to view this content.

**Gti182** · 05-15-2017, 06:15 AM

thanks sintek that works well

Is it possible to only trigger the macro when a cell is changed to any drop down value other than "select"? at the moment when "select" is chosen it executes the code again.

**sintek** · 05-15-2017, 06:27 AM

Sure, change code to:

Please Login or Register  to view this content.

**Gti182** · 05-15-2017, 06:32 AM

a beautiful thing! thanks Sintek works flawlessly

**sintek** · 05-15-2017, 07:31 AM

Pleasure....Thanks for rep point to add....

If Target address method with range of cells

LinkBack

Thread Tools

Rate This Thread

Display

If Target address method with range of cells

Re: If Target address method with range of cells

Re: If Target address method with range of cells

Re: If Target address method with range of cells

Re: If Target address method with range of cells

Re: If Target address method with range of cells

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] If Target.Cells(1).Address = Range("$B$5": ..(?)..)

[SOLVED] Target Address after merging cells

[SOLVED] Worksheet_Change(ByVal Target As Range) - set to only update when 3 target cells changed?

Target.Address as a Range

Extending the Range of 'Target.Address'

[SOLVED] Can you use a Range $N$xx:$Q$xx in Target.Address?

Target.Range.Address Error

Bookmarks

Bookmarks

Posting Permissions