+ Reply to Thread
Results 1 to 2 of 2

Worksheet Code to react to column change

  1. #1
    Registered User
    Join Date
    10-23-2007
    Posts
    80

    Worksheet Code to react to column change

    Hi all,

    I'm trying to write a worksheet code that will run a macro when a certain value is selected in column H. Breakdown is...

    I have 3 macros each called Daily, Weekly, and OneFee.
    In column H of my worksheet (on several rows) I have a drop-down menu (data validation drop-down) that allows you to select "Weekly", "Daily", "One Fee".
    What I want my worksheet code to do is run the relevant macro every time the user selects an option from that drop down menu in column H. I managed to do this when the target was just one cell, but I can't seem to figure out how to do it when the target is the whole of column H.

    Any ideas?

    Many thanks
    Last edited by lealea1982; 07-12-2011 at 09:47 AM.

  2. #2
    Registered User
    Join Date
    06-24-2011
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    36

    Re: Worksheet Code to react to column change

    I might be in left field here, I do not do anything with worksheets at all, but if you have it working for one cell and it need it to work in the entiring column then I dont understand why a "for loop" wouldnt work. Can you post the working code that you have? If need be you can remove any sensitive data from the spreadsheet so long as it reflects what you are currently working with.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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