Hi Mr Excel world! You all have helped me a few times with much more complex items than this so im hoping no to get some help yet again.
I need to create a worksheet that has a form in it. The form is for data entry and needs to contain 7 input areas (text boxes and combos boxes detailed below).
I need to have this so that they click a button named "Start" to call up the form (this button should be above the columns and rows where the form will place the data). Then I want them to be able to add the data and click ok. The form then needs to send the data that they entered to the next empty row and matchup the columns with the proper data.
That is really all the file needs to be able to do.
Here are the inputs that I need on the form (i have been told it helps to be extra detailed in my postings on here)
1. Department (text box about 20 chars)
2. Adv Clinic or LM ID (combo box with Adv Clinic and LM ID as the two options)
3. Code (this is a text box about 20 chars)
4. Course Name or Topic (this is a text box needs to be able to hold at least two sentences of text maybe 100 chars)
5. R or JIT (this is a combo box with R and JIT as the options)
6. Roles Requiring Trng (this is a text box about 50 chars)
7. Timeline (text box with max 20 chars)
The only buttons should be the start button, and then on the form OK and Cancel and Close. Ok to process the data into the cells, Clear to clear the form (not the data that has been entered by others) and Close to close the form.
Any help will be GREATLY appreciated. Thanks so much!
I need to create a worksheet that has a form in it. The form is for data entry and needs to contain 7 input areas (text boxes and combos boxes detailed below).
I need to have this so that they click a button named "Start" to call up the form (this button should be above the columns and rows where the form will place the data). Then I want them to be able to add the data and click ok. The form then needs to send the data that they entered to the next empty row and matchup the columns with the proper data.
That is really all the file needs to be able to do.
Here are the inputs that I need on the form (i have been told it helps to be extra detailed in my postings on here)
1. Department (text box about 20 chars)
2. Adv Clinic or LM ID (combo box with Adv Clinic and LM ID as the two options)
3. Code (this is a text box about 20 chars)
4. Course Name or Topic (this is a text box needs to be able to hold at least two sentences of text maybe 100 chars)
5. R or JIT (this is a combo box with R and JIT as the options)
6. Roles Requiring Trng (this is a text box about 50 chars)
7. Timeline (text box with max 20 chars)
The only buttons should be the start button, and then on the form OK and Cancel and Close. Ok to process the data into the cells, Clear to clear the form (not the data that has been entered by others) and Close to close the form.
Any help will be GREATLY appreciated. Thanks so much!
