I have a Listbox with Multiselect turned on with a rowsource to a named range. There are 5 text choices that feed an 'if' equation on the spreadsheet . I want each of the 5 text choices to link to a particular cell and fill the cell in if selected or leave the cell blank if not selected. Let's just say it's A1:A5.

I have found a lot of possibilities on the web but nothing is working so I'm starting from scratch...this is what I have so far:

Private Sub SensoryObs1_Click()

End Sub
I told you I was starting from scracth! Did you think I was kidding!!!??? :D :D

Any advice?