Double Click on ListBox row

I have a Listbox with 10 rows 1 column, Values from Range(C35:C44)

Please Login or Register  to view this content.

When I double click on one of the rows I want to return the value "1" to the equivalent row in the Range (B35:B44), and all other value in the range to be Zero.
In other words when I double click row 1 in the listbox I want B35 to be "1" and B36:B44 to be zero, and so on for all double clicked rows in the listbox.

I'd prefer not to have to use a "Save" button.
This should be easy code, I just can't workout the best way.. I've got stuck.. any suggestions.
I'm not a programmer so the entire code would be helpful.

Cheers

For "ltb_InjProfile" assign a procedure for the double click event:

Please Login or Register  to view this content.

Tajan Many thanks
..and what would the code look like for a single click .. I would like to use the ListStyle option "1-fmListStyleOption" rather than the plain style

Simon

Tajan.. not to worry I worked it out

Please Login or Register  to view this content.