Writing Data From Form to Cells in Worksheet

**DanSherwood** · 05-04-2007, 10:33 AM

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

**boylejob** · 05-04-2007, 10:57 AM

Hello Dan,

I will normally have my button call a subroutine

Please Login or Register  to view this content.

To get the information from your ListBoxes the format is

UserFormName.ListBoxName.Value

To close the form AFTER you have gotten your data

Please Login or Register  to view this content.

Here is an example from a program I have

Please Login or Register  to view this content.

Hope this will help get you started.

**dominicb** · 05-04-2007, 10:59 AM

Good afternoon DanSherwood

...and welcome to the forum!

This question pops up from time to time. Have a look at my answer to this thread which has a sample file attached, complete with commented code.

http://www.excelforum.com/showthread.php?t=598142

HTH

DominicB