Hi can someone help me please I have a userform i have created. I have created a a portal of links to forms, one of the forms i have made using a UserForm (System_Access) and it has Textboxs, 2 comboboxs and a number of checkboxs. Once the form is completed and send is pressed the information needs to be copied to an external sheet (DataSheet) and then sends a email.
The Email works fine but Im having great difficulty with code for the Combobox and coping the textbox, checkbox data across to the DataSheet. It needs to be possible when more than one checkbox is selected then the name of that box is copied to the DataSheet possibly a listbox.
Can anyone help with me with some code to 1) create the combobox 2) copy the info to the Datasheet. I have attached the example of the 2 sheet for reference.
Thank you in advance
Bookmarks