Thread: Using Many Userforms to record data on worksheet

You should definitely store the data for each form on a separate sheet. You should have a separate sheet for Service1, Service2, Security, etc. In my opinion, it is also more intuitive to put the headers on the top row and the records on subsequent rows instead of puting the headers in the first column and the data in subsequent columns.

If you care to learn, Access is a much better tool for this type of problem.

I don't have the impression you need many userforms.
It looks as if many data are recurring.
It's common practice to consider columns to be 'fields'.
You set up the sheet the other way around.
I would start restructuring.
You won't need many columns, because now you entered all the options too.

In the userform you can reduce the code by rnaming some controls so that the inituialize event can be reduced to:

Private Sub UserForm_Initialize()
  ComboBox1.List = Split("Manned Guarding|Mobile Patrols|Reception Services|Remote Monitoring|CCTV Monitoring|Key Holding", "|")
  For j = 2 To 7
    Me("Combobox" & j).List = ComboBox1.List
  Next
      
  ComboBox8.List = Split("Fixed Price Contract|Fixed Price Contract and Variation Pass Through|Passthrough Costs", "|")
   
  ComboBox10.List = Split("Security Supervisor|Security Manager|Security Officer", "|")
  For j = 11 To 15
     Me("combobox" & j).List = ComboBox10.List
  Next
End Sub