| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Iterate combo box
On Dec 17, 5:04*pm, Mike wrote:
Thanks Chip That is why I am not an MVP, LOL. I would have figured it out if I had tested the code before posting it. "Chip Pearson" wrote: For i = 1 To ComboBox1.ListCount - 1 The i variable should start at 0 not 1. Cordially, Chip Pearson Microsoft MVP * * Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Wed, 17 Dec 2008 08:31:03 -0800, Mike wrote: Try this Private Sub CommandButton1_Click() For i = 1 To ComboBox1.ListCount - 1 * MsgBox Me.ComboBox1.List(i) Next End Sub "inungh" wrote: I would like to iterate combo box to get all result in a loop. I try to use cmbMyCombo.count, but Excel does not support the property. Are there any property that I can access for this iterate combo box? Your information is great appreciated,- Hide quoted text - - Show quoted text - Thanks millions, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sub to iterate thru combo box n copy paste n name ranges successively in a new sht | Excel Programming | |||
| Sub to iterate thru combo box n copy paste n name ranges successively in a new sht | Excel Programming | |||
| Iterate through a form | Excel Programming | |||
| Can't iterate thru a row with For | Excel Programming | |||
| Newbie question: How to iterate over combo boxes on a worksheet | Excel Programming | |||
Threaded Mode
