I'm new in Macro Excel and would like to ask for your help. Here's what I'm doing:

I created a user form with the following fields, Products, Supplier, Location, Owner, Date.
I want it to be display the information in 3 seperate places. First, a Log. Second, I want their name to be displayed on the calendar sheets I've created and last to create a calendar invite/event in Outlook.

Basically it is for Supplier Meeting Schedule, if someone wish to create an event, I would like to click Add Item on the Home Tab, and have it show the UserForm to input Data, and then record it to the Calendar, below the Correct Date,...

I'm also thinking of Recurrence option in the UserForm, if the user would like to create an event that will recur weekly or monthly.

Can this be done, the way it is currently formatted?


Thanks....