Results 1 to 26 of 26

Executing Macro based on cell contents

Threaded View

  1. #1
    Registered User
    Join Date
    09-13-2018
    Location
    canada
    MS-Off Ver
    office 2013
    Posts
    27

    Executing Macro based on cell contents

    I'm trying to have it so when a specific cell is filled out with specific text it runs a specific macro. This macro populates a specific range of cells relative to the text cell (example cell A1)


    so:

    IF
    A1="text1"
    THEN
    Execute 'Macro1' (which fills range C1:D5)

    I also want to be able to set other possible text values to run other macros, example: text2 runs macro2, text3 runs macro3, etc.

    In a nutshell:

    If trigger text in A1 is typed, Macro will run and paste specific range of text in C1:D5

    Now I need this to be relative, so if this same text is typed in A10, for example, the macro will now populate C10:D15

    Or perhaps there's a way to do this without macros, as each of the desired "paste" items have named ranges.

    Thanks!
    Last edited by m_roussakis; 09-27-2018 at 03:50 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel Macro to find cell in worksheet based on contents of another cell
    By MeBeMel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-13-2017, 11:37 AM
  2. Need a macro to add 1 to active cell based on previous cell contents
    By wtom in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-20-2014, 12:16 AM
  3. Macro to move row based on cell contents
    By alpha608 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-17-2013, 04:08 AM
  4. [SOLVED] Need help writing macro to replace one cell based on contents of adjacent cell
    By TheRaptMuse in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-24-2012, 12:54 PM
  5. Macro that will clear contents of cell based on format of text in adjacent cell
    By judasdac in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-12-2012, 01:56 AM
  6. Run macro based on cell contents
    By Billip in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-16-2011, 06:55 PM
  7. Executing a macro based on worksheet change
    By Rynofasho in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-07-2010, 08:44 PM

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