Excel VBA Run-time error '380' Could not set the Value Property

[LukeP1]

Hi,

I am trying to write VBA code to update a list box value based on cell value in the active row. The code below is retuning a '380' error. Can anybody assist to resolve. ?

Many Thanks

 

[bobsan42]

What are the listbox properties? How many columns, which is the bound column, what value and type does the listbox return and what value are you trying to assign, is it a value from the list ... ?
Why not just setup bh5 as bound cell for the listbox?