+ Reply to Thread
Results 1 to 7 of 7

Userform extract data from sheets based on datepickers and graph results

  1. #1
    Registered User
    Join Date
    11-05-2014
    Location
    Cleveland, Ohio
    MS-Off Ver
    2010
    Posts
    4

    Exclamation Userform extract data from sheets based on datepickers and graph results

    Hey Everybody,

    I need some help from someone who is a whole lot better at coding than I am. It's just a little bit beyond my knowledge.

    I have a userform that a user enters data into textboxes and then puts the data into separate sheets of a workbook. I have a 2 date picker controls and I need for it to extract all the data of the separate sheets from the ranges of the date picker controls and graph the results.

    If you need, I can email the workbook so you can see better what I'm trying to do.

    Thanks in advance,
    Myke
    Last edited by 6StringJazzer; 11-05-2014 at 12:03 PM. Reason: title

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Macro Help

    Nice username.

    You don't need to email files, unless it contains data that you don't want to post and it is not feasible to create a sanitized version. To post a file:
    1. Under the text box where you type your reply click the Go Advanced button.
    2. In the next screen look above the reply box and click the "paper clip" icon. You will get a pop-up screen.
    3. In the pop-up, click Add then Select to select a file from your local drive
    4. Click the Upload button to upload the file
    5. Click Done to attach it.

    It will be displayed as an attachment underneath your post text. Alternatively as the last step you can click the Insert Inline button and a hyperlink to the file will be inserted directly into your post text in the spot where your cursor is set at the moment you click the button.

    Here are step-by-step instructions with screen shots

  3. #3
    Registered User
    Join Date
    11-05-2014
    Location
    Cleveland, Ohio
    MS-Off Ver
    2010
    Posts
    4

    Re: Macro Help

    Attached is the file.

    Thanks for the help,
    Myke
    Attached Files Attached Files

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Userform extract data from sheets based on datepickers and graph results

    Your VBA is password protected. Please revise the attachment to remove the password, or provide the password--thanks.

  5. #5
    Registered User
    Join Date
    11-05-2014
    Location
    Cleveland, Ohio
    MS-Off Ver
    2010
    Posts
    4

    Re: Userform extract data from sheets based on datepickers and graph results

    Sorry, I forgot about that.
    Attached Files Attached Files

  6. #6
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Userform extract data from sheets based on datepickers and graph results

    I can't run your file because I don't have Microsoft Calendar Control. I'm going to have to pass on this one.

  7. #7
    Registered User
    Join Date
    11-05-2014
    Location
    Cleveland, Ohio
    MS-Off Ver
    2010
    Posts
    4

    Re: Userform extract data from sheets based on datepickers and graph results

    Okay ... Thanks for trying

+ 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. Using a macro on workbook1 to create a button in wb2 and assigning macro "wb2!macro"
    By penfold1992 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-13-2014, 11:39 AM
  2. [SOLVED] Macro to show Which macro didnt work in a nested macro
    By akhileshgs in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-10-2013, 03:21 AM
  3. Perform macro "on open" specific file- store macro in Personal Macro Workbook?
    By thompssc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2012, 12:38 PM
  4. lookup macro, solver macro, realtime macro
    By xelhelp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-02-2011, 06:14 PM
  5. Cannot find macro error when running a macro from a macro in a diffrent workbook.
    By Acrobatic82 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2010, 09:22 AM

Tags for this Thread

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