Results 1 to 4 of 4

Integrating Calendar with WorkSheet and UserForm

Threaded View

NoobExcel12 Integrating Calendar with... 11-24-2017, 05:45 AM
NoobExcel12 Re: Integrating Calendar with... 11-29-2017, 04:00 AM
mjr veverka Re: Integrating Calendar with... 11-29-2017, 04:35 PM
NoobExcel12 Re: Integrating Calendar with... 12-01-2017, 09:17 AM
  1. #1
    Registered User
    Join Date
    11-21-2017
    Location
    LEBANON
    MS-Off Ver
    2016
    Posts
    4

    Integrating Calendar with WorkSheet and UserForm

    Hello,

    I would like to Integrate Calendar with a Worksheet and a Userform.
    My file is attached.

    I Have a userform where I enter a new entry for my data sheet (Transportation_Tracking).
    My wish is after I enter the data, the name depending on THE DAY and THE TIME will be insert automatically in my calendar to the accurate Cell. Like a Planning Table.

    In my File, I have put in green the cell (in transportation_tracking sheet) the criteria that need to be in consideration.
    In my file, I have put the Name Robert in the cell corresponding at my data sheet in the Calendar.

    The goal is then to automatically Insert the Name ROBERT in the calendar depending on the Transportation_tracking Sheet when I finish to enter the entry in my userform.

    Userform = Enter information in the data sheet (transportation_tracking) and put the name in the accurate cell (depending on Day and Hour)

    Is it feasible ?

    Thanks in advance guys
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Userform - integrating code from old form into new template, timestamp, ID No etc
    By excelconditional in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-29-2017, 04:37 PM
  2. Activation of Userform Hide Worksheet and Closing Userform Activates Worksheet
    By Newmord in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-14-2014, 11:18 AM
  3. [SOLVED] Excel 2007, Userform Textbox Date Format and Calendar Control Userform
    By riffology in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-03-2014, 06:18 PM
  4. [SOLVED] vba userform calendar to populate textbox in another userform
    By kaurka in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-29-2012, 01:43 PM
  5. Using a userform Calendar to fill in an excel calendar, and also a log
    By 00Able in forum Excel Programming / VBA / Macros
    Replies: 64
    Last Post: 09-08-2011, 08:50 PM
  6. Integrating a worksheet from another workbook?
    By gogofor8 in forum Excel General
    Replies: 3
    Last Post: 05-27-2010, 08:17 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