+ Reply to Thread
Results 1 to 3 of 3

Run a macro off a command button if a specific date is choosen

  1. #1
    Registered User
    Join Date
    01-29-2015
    Location
    Oregon
    MS-Off Ver
    MS Office 10
    Posts
    2

    Exclamation Run a macro off a command button if a specific date is choosen

    So basically what I am trying to do is set up a randomized assignment for our staff on who will perform QA for other staff members.

    I have two issues that I cannot seem to fix:

    Issue 1) I have a drop down menu that selects a month so that the assignments are for that specific month. There are some specific parameters that have to be met before allowing an assignment and I have all those set up as conditional formatting (if one of the parameters are met, it's highlighted in REd). How can I create a code that cyles through the randomization until there is no more red, as opposed to the recalculate function I have set already. (and not to create an infinate looping cycle)

    Issue 2) I have created a macro that, when a manager clicks the "generate QA assignment" button, it would copy and paste the values for that month. Currently, my code isn't working and I am about to pull out my hair.

    Any advice of any kind would be great!

    Thank you!
    J

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Run a macro off a command button if a specific date is choosen

    It would probably useful to attach a sample workbook to the site so we can see what you are trying to do.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    01-29-2015
    Location
    Oregon
    MS-Off Ver
    MS Office 10
    Posts
    2

    Re: Run a macro off a command button if a specific date is choosen

    Oh geez, duh, that would help huh?

    Okay here is what I have.
    Any help would be great.
    Attached Files Attached Files

+ 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. Need help creating specific "add-row" macro using a command button
    By rmtreadw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2014, 10:01 PM
  2. How to give specific Name to command button in shet1?
    By shiva_reshs in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-18-2013, 12:12 PM
  3. [SOLVED] how to stop Command button If specific number is entered in a specific cell range
    By sspreyer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-26-2013, 05:10 AM
  4. Copy entered data for a specific date using a command button
    By SChapman in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 03-31-2013, 05:38 PM
  5. Command button to send an email based on a specific date
    By suetuff in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-29-2013, 04:25 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