Basic VB Code Needed - HELP, Gurus!

Valencia · Apr 8th, 2002, 03:30 PM

I'm working in Excel 97.

I just need to know the CODE to type in order to format my drop-down list box.

When I get to Visual Basic, it's ready for me to enter CODE into the following:

Private Sub ComboBox1_Change()

(I guess I enter some stuff here?)

End Sub

When the drop-down arrow is pressed, I want the box to read:

Michael
38
17%

Can anyone help me? I really appreciate your taking the time.

Al Chara · Apr 8th, 2002, 03:54 PM

You have to edit your ListFillRange.

Go into design mode and right click on your combobox and goto properties. If you data is in Cells A1:A3 then next to the ListFillRange box enter in A1:A3.

Apr 8th, 2002, 03:54 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	You have to edit your ListFillRange. Go into design mode and right click on your combobox and goto properties. If you data is in Cells A1:A3 then next to the ListFillRange box enter in A1:A3. __________________ Kind regards, Al Chara

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

Apr 8th, 2002, 03:30 PM	#1
Valencia New Member Join Date: Apr 2002 Location: Everywhere Posts: 3	I'm working in Excel 97. I just need to know the CODE to type in order to format my drop-down list box. When I get to Visual Basic, it's ready for me to enter CODE into the following: Private Sub ComboBox1_Change() (I guess I enter some stuff here?) End Sub When the drop-down arrow is pressed, I want the box to read: Michael 38 17% Can anyone help me? I really appreciate your taking the time.