Form Controls / Active X controls to record and log information in a seperate sheet

Hi - this may be simple but hope its not a stupid question

I am looking to create a form which will record information in a seperate sheet based on user selections.

The first criteria / option the user could select will contain 4 options (user should be unable to make multiple selections in this list)

The second criteria / option the user could select will contain 12 options (user should be unable to make multiple selections in this list)

Once both options have been filled the user will click submit, the form resets itself and the information is recorded in a seperate sheet.

The process can be repeated up to 50 times a day and I want to be able to view the information in a list.

Any help will be appreciated.

Thanks Guys

Hi sorry my explanation wasnt very good.

I will attach an example which hopefully will explain more

new enquiry log template.xlsm attachement

I'd do it like this

Thanks Kyle,

Can you elaborate on what you used / did so I can refer back to it?

Thanks

I've uploaded a workbook? So I'm a bit confused, specifically, what are you asking?

Basically how you done it

Created dynamic ranges for the two listboxes so adding items is easy.

Set the source range of the listbox to the dynamic range

Added a macro that takes the values of the 2 listboxes and adds them to the next available row in the data sheet along with the date and time

Have you looked at the code?