I have a worksheet with a multiselect listbox poplated with three items. I would like to set certain cell values based upon whether a listbox item is selected. So - cell A1 should =True if Listbox1.selected(0) = true and A1= false if Listbox1.selected(0)=false. Same for cells A2 and A3 according to the selection status of the second and third list items. How do I do this please? I can only seem to make this happen if I create a command button which sets the cell values when clicked. However I would like the cell values to be changed upon clicking in the listbox. Thank you!