+ Reply to Thread
Results 1 to 1 of 1

Use a UserForm for retrieving Data from excel calendar

  1. #1
    Registered User
    Join Date
    Houston, Texas
    MS-Off Ver
    Excel 2007 and 2013

    Use a UserForm for retrieving Data from excel calendar

    Hello Gurus,


    I'd like to use my Userform to retrieve data from my excel calendar. For instance:

    When my Userform is called—through a commandbutton—I would like the textbox labeled "date" to display the current date and business day and the texbox labeled details to display all the deliverables (or tasks for the day) listed under that specific date. I'd also like to be able to update the data if needed with the userform.
    So far I’m able to make my userform pop up when the workbook is opened. Now, I’d like it to pop up when the workbook is opened and display my deliverables for the day.

    Also, On the top right corner of the calendar sheet, I was able to pinpoint the total # of business days—however I’d like to pull the current business day (BD) from the calendar. Would that be an “if” statement? If __=today then _=BD 9?

    Can anyone help guide me through this?

    2013 Team calendar v3.xlsm

    Attached is a copy of my first draft for review.
    Last edited by ChiBaby; 04-04-2013 at 11:29 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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