Hi,
I have a userform which contains 3 list boxes and 2 text entry fields, where the user will enter a date in each in format ddmmyy.
The form has a submit button at the bottom.
What code do i need on the submit button to be able to write the values in the list boxes and the text (date) fields into a set of cells in one of the worksheets once clicked, also closing the form once clicked and leaving the selections in the relevant cells?
E.g. I want listbox1 selection in cell B10 and listbox2 in B11, listbox3 in B12 etc etc.
Thanks in advance for any help.
Dan
Bookmarks