Creating a data entry form with drop down box

Question

Hi and hope some one can assist me we have a very simple stock management Excel spreadsheet set up - I would like to create a data entry from that allows the team to enter the orders in BUT I want to only allow certain values at the moment they are set up as a drop down - if I click the form it will not show me the dop down 

they only have to enter 4 pieces of imformation

Order number (number)

Order Date (date)

Product (this is the one from the drop down that I want to restrict to)

Quantity (number)

this then links to the stock tab and reduces the specific stock by that value (this is already done)

A client on the same order number can order more that one product so it would be fabulous for the data form to create a line for each product in the Excel spreadsheet so that the data team dosnt have to enter the order number and order date twice

Does any one have a fabulous way that I can achieve this please - maybe I need to get someone to write a code for me???

Many thanks in advance 

Sam

Answer 1

Hi Samantha

To find solution to your question

I'd Request you, please.

1- Post a screenshot of your worksheet without any confidential / sensitive data.

Also post the results expected.

Make sure that your row numbers and column letters are visible in the screenshot.

OR the best option

2-Prepare and upload a sample / dummy file with no confidential / sensitive data

to Onedrive, DropBox... and share the link here.

This would help us to understand your problem better and come up with a solution. 

Do let me know if you require any further help on this.

Regards,

Answer 2

I would create a userform with Textbox controls for the Order number and Order date (though a date picker could be used for that, and then one list box that would be populated with all of the products arranged on the left size of the form with second list box arranged on the right side, with one command button in the middle that would add an item (product) selected in the left list box to the list box on the right, following which the user would be asked for the quantity of that product, which would be inserted into a second column in that listbox.  There would also be a button to allow an item to be deleted from the second list box.  There would also be a command button that when used after all of the selections had been made, would write the data to the form.

While having a list of the products in Excel is a good location for it, I would really suggest that the userform be created in Word and that the order be created as a Word document.

See the following pages of Greg Maxey's website :

http://gregmaxey.mvps.org/Create\_and\_employ\_a\_UserForm.htm

http://gregmaxey.mvps.org/Populate\_UserForm\_ListBox.htm

http://gregmaxey.mvps.org/word\_tip\_pages/populate\_userForm\_listbox\_or\_combobox.html

Below is an example of the sort of form from another application, albeit with a bit more functionality than you are wanting

Answer 3

thanks so much doug I did know this could be acheved in word - I will have a play thanks