Results 1 to 6 of 6

If Target address method with range of cells

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-04-2010
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    455

    If Target address method with range of cells

    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

    
    Option Explicit
    Private Sub Worksheet_Change(ByVal target As Range)
    If target = Range("D3:D5") Then
    If cell changes, <> "Select" execute another macro
    end if
    Attached Files Attached Files
    Last edited by Gti182; 05-15-2017 at 06:32 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] If Target.Cells(1).Address = Range("$B$5": ..(?)..)
    By Marcin4111 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-22-2015, 06:57 AM
  2. [SOLVED] Target Address after merging cells
    By tanvi_kalra in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-10-2014, 02:45 AM
  3. [SOLVED] Worksheet_Change(ByVal Target As Range) - set to only update when 3 target cells changed?
    By trillium in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-07-2012, 06:40 PM
  4. Target.Address as a Range
    By wotsup in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-03-2012, 06:30 AM
  5. Extending the Range of 'Target.Address'
    By Mhz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-16-2007, 02:08 AM
  6. [SOLVED] Can you use a Range $N$xx:$Q$xx in Target.Address?
    By CRayF in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-29-2005, 08:05 PM
  7. Target.Range.Address Error
    By markshowell in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2005, 10:42 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1