Posted to microsoft.public.excel.programming

GS[_2_]

external usenet poster

Posts: 3,514

Iterating through a ComboBox's values

Example...

Sub IterateComboboxList()
Dim i As Integer
For i = 0 To Sheets(1).ComboBox1.ListCount - 1
Debug.Print Sheets(1).ComboBox1.List(i)
Next 'i
End Sub

Results in Immediate Window:

Apple
Banana
Orange

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Iterating through cells, comparing values	kingpin2502	Excel Programming	0	July 11th 05 06:08 PM
Offset & Combobox's returned Value	Anat Sn	Excel Programming	1	December 25th 03 03:57 PM
Referring to OLEObjects (combobox's on worksheet)	Ian Chappel[_2_]	Excel Programming	4	September 22nd 03 05:31 PM
checking for errors in combobox's	Bob C[_2_]	Excel Programming	1	September 4th 03 09:03 PM

All times are GMT +1. The time now is 01:31 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us