rharri1972
Board Regular
- Joined
- Nov 12, 2021
- Messages
- 132
- Office Version
- 2019
- Platform
- Windows
Hello! So I have been trying to learn as I go and ask "how to's" with each step thinking it would be easiest but in turn I think I have just aggravated a couple of people which was NEVER my intent. My entire goal is to build a database for my company. I kind of understand VBA but it still takes me hours to disect code and there is SO MUCH i have no clue about. So this time I am spilling everything I need per userform and I hope not to over complicate things.
I have a userform "Customer Order". I will manually put in information into this form to process a customers order. It will contain labels, textboxes and combo boxes. I will have a command button "OK".
On the click of the command button, I want to send all data to a worksheet to be captured.
For each customer there is a Customer ID. The worksheet will be named after this Customer ID. (typed in the tab)
Example Customer ID would be like PIL1500
TEXTBOX 1 will contain the Customer ID.
Textbox 1 = Customer ID
Textbox 2= Order Date
Textbox 3 = PO number
ComboBox1 = Customer Name
Textbox 4 = Address (street address)
Textbox 5 = City
Textbox 6= State
Textbox 7=Zip
The worksheet will be the same order Left to right Starting with A2:H2.
Row 1 being left for Column Headers.
would also want to make sure that when executing that the data be placed in the next available row.
Any and all help will be greatly appreciated. There will be more questions to come once i am able to complete this step and then move on to the next userform.
Thanks!
I have a userform "Customer Order". I will manually put in information into this form to process a customers order. It will contain labels, textboxes and combo boxes. I will have a command button "OK".
On the click of the command button, I want to send all data to a worksheet to be captured.
For each customer there is a Customer ID. The worksheet will be named after this Customer ID. (typed in the tab)
Example Customer ID would be like PIL1500
TEXTBOX 1 will contain the Customer ID.
Textbox 1 = Customer ID
Textbox 2= Order Date
Textbox 3 = PO number
ComboBox1 = Customer Name
Textbox 4 = Address (street address)
Textbox 5 = City
Textbox 6= State
Textbox 7=Zip
The worksheet will be the same order Left to right Starting with A2:H2.
Row 1 being left for Column Headers.
would also want to make sure that when executing that the data be placed in the next available row.
Any and all help will be greatly appreciated. There will be more questions to come once i am able to complete this step and then move on to the next userform.
Thanks!