Results 1 to 20 of 49

Thread: MACRO: IF THEN Statement (Multiple Criteria Match then Copy)

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #28
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,888
    Location
    Quote Originally Posted by snb View Post
    Is this a question or an assignment ? (to be paid for)

    https://en.wikipedia.org/wiki/Feature_creep


    This started out as using a simple event handler to take a US State in one column and enter an associated US Region in another

    http://www.vbaexpress.com/forum/show...ered&highlight=


    There have more than a few additional requests

    I don't mind implementing them (on a 'when I get around to it' basis) but if I had known the final (OK, current) scope I would have either

    1. Have passed it by, or

    2. Planned the architecture a lot better



    I really don't mind doing it, but had I had a better long range view of the requirements, I would have done things a lot more gracefully
    Last edited by Paul_Hossler; 04-17-2017 at 09:38 AM.
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

Posting Permissions

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