PDA

View Full Version : Writing userform List Box entries into a worksheet



matty1991
07-06-2016, 05:00 PM
Good morning all

I have a userform which our staff complete and then the entries get inputted into a worksheet.

I have a list box which lists out 10 different documents we require our clients to provide us, I then have three other list boxes which represent if the documents were missing, expired or had an error.

Now I've coded the add and remove buttons for the list boxes but I am stuck on how to get the items that are added into the Missing, Expired and Error list boxes to write into corresponding cells in the worksheet.

The rest of the userform is made up of drop downs and text boxes which I haven't had any issues with coding them to transfer across it's just these lists which are stumping me.

I am an extreme noob when it comes to VBA so I apologise in advance.

16564

Kindest Regards

Matt :hi: