I've produced a userform with a drop-down list with items such as chair, table, bed etc. When i select one of them (eg. chair) , and press the command button to select the item, it flashes up with all of them and goes back to the original chosen one.

HELP! Whats going on?!

How do i get them to show up on the spreadsheet individually??!!!