Add new Item to SharePoint List using VBA Userform

Hi All,

I'm currently working on an advisor feedback form for my company to make use of. the proposed way for it to work is for an Excel userform to come up, this to be filled in by a customer advisor and then once it's submitted, to add the information to a SharePoint list without negatively impacting any of the existing data that's on the list.

The key issue here is that i do not want anyone who opens the userform to be able to see the sharepoint list at all, so importing the list to excel, updating and then exporting it back to SharePoint doesn't seem to be a viable option for me.

Does anyone have any ideas of how i can just submit data straight to sharepoint?

any assistance would be greatly appreciated

Hi Guys,

is anyone able to help out with this?

Thanks again