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.

 

[RoryA]

How is your listbox populated? Using RowSource? If so, you'll need to add the data to the source worksheet and then update the rowsource property to include the new row.

 

[vhdhfox]

Yeah the list box is populated using the RowSource but can change if needed as im wanting to use this userform to update the values of the selected row.
At the moment I have 1 Userform for inserting the data to the source worksheet and then this userform which will display all data in that work sheet which can then be updated from this second userform

 

[RoryA]

You can still use Rowsource, you just need to update the sheet, not the listbox, as I mentioned. Personally, I don't like to directly link controls to worksheets unless necessary, but it looks like you are using column headers, which does require the use of rowsource.

 

[vhdhfox]

By updating the worksheet do you meaning updating it by using the data entered into the textboxes and then having the listbox refresh to update the new values?

 

[RoryA]

Yes. The refresh should happen automatically.

 

[vhdhfox]

would it be possible to update the cells of the row that's selected in the listbox?

 

[RoryA]

Yes, you can update any cells you like. Just be aware that changing cells that are part of the Rowsource will most likely clear the selection in the listbox, so you should store the current listindex and reset it again.

 

[vhdhfox]

Instead of using the rowsource how would I go about populating the list box and then also what code would I use to update the cells from the userform?

 

[RoryA]

If you don't use Rowsource, you won't be able to use column headers which look to be fairly important given the number of columns in your listbox.