Form to fill in data help

[oneblondebrow]

Hi all,

I am looking at having a form on the attached spreadsheet that gets the user to add the data on it and not directly onto the spreadsheet, I started to create a Form on the sheet as you can see if you press ALT - F11 and have it how I want it by following an online tutorial, Only issue is I have no idea what VBA to add to the buttons do what I want them to do.

So I want the DATE text input box to firstly only allow the format 00/00/0000, Then the e number (stands for employee number), Start time and end time need to be in this format 00:00:00, Issue Area/Base During Outage and Equipment Provision will be drop down lists, INC number allows them to put an Incident number in and then Comments goes into the "issue notes" section. I would like it so you press a button or ENTER and this data populates the relevant sections on the sheet, There may be multiple entries.

I know this is a massive task and I think it is way out of my realm of excel skills and was hoping someone here could help me with it?

Thanks in advance.

[mike7952]

Here is a start. I added a form (Form2) with a calendar for selecting a date for textbox1. Just click the button to the left of the textbox. Also for textbox2 employee number I have it so only number values are allowed. Time textboxes I have set up for 00:00 - 23:59. And the Issue Area/Base combobox is filled with the values from your Example Worksheet Column A.

[oneblondebrow]

Thanks for the above , I have been trying a little bit myself by following some online tutorial but have got a bit stuck, I have attached where i am so far and would love to integrate what you have done into it, I have tried but i just seem to mess it all up, Also anyway that this entry box can start up with the spreadsheet and only be cleared if you press cancel?

[mike7952]

Give the attached workbook a try.

[mike7952]

Also anyway that this entry box can start up with the spreadsheet and only be cleared if you press cancel?

Not sure what you mean?

[oneblondebrow]

This is getting there, Love the Time entry code

The E numbers are a mixture of letters and numbers so although I like the way it will only accept numbers it doesn't work in this instance

The Calander thing doesn't work, Form 2 is empty, Do I need to create a calendar for it and use that? Or could you do it like the times and allow only the format of DAY/MONTH/YEAR to be added (in the UK format)

Also anyway I could add the other 2 drop down boxes as well?

I was also wondering if I can have it so this script starts on opening the spreadsheet, The cancel button is for if we want to go back into the spreadsheet behind and edit in there, the next button is to blank the form so another lot of data can be added.

Thanks for the help so far