Listbox to insert data to selected line

[vhdhfox]

Hi

currently I have a userform with a listbox that displays the data I've selected in textboxes but whatever code I try to insert the new data to either the listbox or cells of the highlighted line in the list box I get error "70" listbox does not have permission.

 

[vhdhfox]

Okay so I've been playing around with other ideas instead of using rowsource and decided to go with the below code which works fairly well for what I want as I have lined the columns up with the textboxes above the listbox

Sub UserForm_Initialize()

    Dim rngMultiColumn As Range
Set rngMultiColumn = ThisWorkbook.Worksheets("Allocate").Range("A2:O13")
With AllocateFitler.AllocateBox1
.ColumnWidths = "40;40;60;95;30;30;30;90;60;70;75;85;30"
.List = rngMultiColumn.Cells.Value
End With

End Sub

im just having trouble with inserting these lines once the data has been updated I.E. when someone selects a line in the listbox they can then update that data or add values in textbox 1,2,5.

im not sure if its possible but I would like to be able to have a command button that either deletes or replaces the data on the worksheet the data is stored based on what row in the listbox is selected.

Thanks for your help and apologies for the late reply Rory

 

[RoryA]

Since your data starts in row 2 and the listbox's ListIndex property starts at 0, all you need to do to get the correct row number for the cells is add 2 to the Listindex.