+ Reply to Thread
Results 1 to 2 of 2

Get this macro to run automatically.

  1. #1
    Registered User
    Join Date
    05-03-2018
    Location
    Los Angeles
    MS-Off Ver
    2013
    Posts
    11

    Get this macro to run automatically.

    Below I have this macro set up with the help of other users.

    My macro right now does two things. The top portion is where the concern is.
    This macro is supposed to prompt the user to enter a date in G2 whenever F2 is True. F2's truth value is linked to a checkbox (not ActiveX). The only way I can get this to work is if I click on F2 once then the prompt comes up. The intent was to have the prompt come up immediately after F2 truth value became true. Am I missing something?


    Please Login or Register  to view this content.
    Last edited by vs27739; 05-08-2018 at 05:35 PM.

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,137

    Re: Get this macro to run automatically.

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    My Rules if you want my help:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy row macro not automatically assigning macro to checkbox
    By darbar76528 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-11-2017, 12:32 PM
  2. Automatically Open Excel and Run Macro When New File Automatically Detected
    By jamesdeuce in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-07-2016, 11:35 PM
  3. Macro to export and import a module and assigning different macro automatically
    By Libster78 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-14-2015, 06:31 PM
  4. problems with macro to automatically fill the username and macro to unhide sheets
    By djtosh1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-07-2015, 07:14 AM
  5. Replies: 0
    Last Post: 01-15-2013, 08:18 PM
  6. Automatically activate macro when data is inputed instead of manually activating macro
    By sonny.thind in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-12-2012, 08:45 AM
  7. Replies: 3
    Last Post: 08-11-2008, 09:21 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