Desperate for help......!!!!!!!!

[Frankie needs HELP]

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??!!!

 

[hennahairgel]

you need a bit of code in the userform. eg

For p = 0 To ListBox1.ListCount - 1
If ListBox1.Selected(p) Then

enter your code in here....

End If
Next p

 

[Frankie needs HELP]

What is 'p'?

Is that where i put the item?

 

[hennahairgel]

I'm just using it as a varible!
It could be anything, but is used in this to as the step counter in the FOR loop.