Use userform to add data to seperate workbook using combo box to select workbook.

[thomastturner]

Firstly I'm new to VBA, as you will find out. So is this possible?

I'm wanting the information in a combobox to open a specific workbook on our network, and add other fields in the Userform to different columns in that workbook. I really want it to do it silently. I've created a Frankenstein Userfrom from different code I've found around the internet, made some changes to suit my needs.

This is what i'm wanting to accomplish...

Agent Name = Which workbook to open.
I'm wanting to add the data to Workbook "Agent Name".xlsm -> Worksheet Coaching Log 2015 in that workbook
Date Issued = Column A
Coach = Column B
Type = Column C
Reason = Column D
Notes = Column E

If you need more information, please let me know. Thanks!