I've created a combobox and filled the data with values from a named range, called "Kunden_mit_Adresse". Here is my code:
'Set reference to the range of data to be filled
Set rngSourceKunde = Worksheets("Kunden").Range("Kunden_mit_Adresse")
'Fill the listbox
Set lbtarget = Me.lstKundenListe
'Determine number of columns
.ColumnCount = 6
'Set column widths
.ColumnWidths = "0;130;110;20;0;20"
'Insert the range of data supplied
.List = rngSourceKunde.Cells.Value
As you can see, I've created several textboxes. When a customer is selected from the combobox, I wish the data to be displayed in the textfields and
be able to change the values (in the spreadsheet). See attached spreadsheet example.
My goal is that a customer's data can be changed with an Excel userform.