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

Frankie needs HELP · May 1st, 2002, 10:11 AM

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 · May 1st, 2002, 11:03 AM

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 · May 1st, 2002, 11:38 AM

What is 'p'?

Is that where i put the item?

hennahairgel · May 2nd, 2002, 06:28 AM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 1st, 2002, 10:11 AM	#1
Frankie needs HELP New Member Join Date: Apr 2002 Posts: 43	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??!!!

May 1st, 2002, 11:03 AM	#2
hennahairgel New Member Join Date: Feb 2002 Location: Bristol, England Posts: 39	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

May 1st, 2002, 11:38 AM	#3
Frankie needs HELP New Member Join Date: Apr 2002 Posts: 43	What is 'p'? Is that where i put the item?

May 2nd, 2002, 06:28 AM	#4
hennahairgel New Member Join Date: Feb 2002 Location: Bristol, England Posts: 39	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.