A user fills a userform and I save the contents into a sheet.
I want, after opening the sheet, to populate the form with the saved data.
I write the data with;
For Each cCtl In begin.Controls If TypeOf cCtl Is MSForms.CheckBox Then Cells(y, 1) = cCtl.Name Cells(y, 2) = cCtl.Value y = y + 1 End If If TypeOf cCtl Is MSForms.TextBox Then Cells(y, 1) = cCtl.Name Cells(y, 2) = cCtl.Value y = y + 1 End If
This works and (some of) the results are:
- cbklant Agentschap Telecom,
- labelklant Omschrijving,
- cbcalc Con van Doornik,
- cbkans 50%
in cell A1 to B4 etc.
(cb = comboboxname)
(label = Labelcaption)
How do I populate the form from this
Range by opening the file?