VBA to enter form values in sheet

**sammi1234** · 02-01-2014, 08:40 AM

I have a form that I created that has several fields that I want it to enter into specific cells on my worksheet. The information should just rewrite into those same fields everytime they enter data into those fields.

When I hit "Enter" on my form I want it to:

Enter Combobox Field 1 into A1
Enter Text Field 2 into B1
Enter Combobox Field 3 into C1
Enter Text Field 4 into D1
etc.

Thanks for any help you can provide.

**stnkynts** · 02-01-2014, 09:57 AM

Please Login or Register  to view this content.

**tony h** · 02-01-2014, 09:58 AM

in design mode when you doubleclick the control you will open the click event for that control. this is where you put code to run on clicking (there's a surprise!)

on the panel above on the right there is a dropdown showing other events available.

You then have a choice of whether to save the values on the initial change or have an OK-button. either way the control event gives you what you need.

to reference the cells you can use the

thisworkbook or activesheet
or all or part of
workbooks("workbook.xlsm").sheets("mysheet").range("C1") = textextbox.value

hope this help you get going