I'm looping thru the items of combobox list, it works fine but at the end
shows an "invalid use of Null" error as if an additional item that can't be
recognized existed.


For Each In CbxAddress.List
MsgBox ccc
Next ccc


Thanks in advance

dim iCtr as long
for ictr = 0 to cbxaddress.listcount - 1
msgbox cbxaddress.list(ictr)
next ictr


LuisE wrote:

I'm looping thru the items of combobox list, it works fine but at the end
shows an "invalid use of Null" error as if an additional item that can't be
recognized existed.

For Each In CbxAddress.List
MsgBox ccc
Next ccc

Thanks in advance

--

Dave Peterson

Dave,
Thanks for the reply.

What I have listed in the combobox is a range of letter representing, so it
won't fork with integers. The way I wrote the code it works but I can't avoid
the last loop -1

"Dave Peterson" wrote:

dim iCtr as long
for ictr = 0 to cbxaddress.listcount - 1
msgbox cbxaddress.list(ictr)
next ictr


LuisE wrote:

I'm looping thru the items of combobox list, it works fine but at the end
shows an "invalid use of Null" error as if an additional item that can't be
recognized existed.

For Each In CbxAddress.List
MsgBox ccc
Next ccc

Thanks in advance

--

Dave Peterson

Try it. You may be surprised.

LuisE wrote:

Dave,
Thanks for the reply.

What I have listed in the combobox is a range of letter representing, so it
won't fork with integers. The way I wrote the code it works but I can't avoid
the last loop -1

"Dave Peterson" wrote:

dim iCtr as long
for ictr = 0 to cbxaddress.listcount - 1
msgbox cbxaddress.list(ictr)
next ictr


LuisE wrote:

I'm looping thru the items of combobox list, it works fine but at the end
shows an "invalid use of Null" error as if an additional item that can't be
recognized existed.

For Each In CbxAddress.List
MsgBox ccc
Next ccc

Thanks in advance

--

Dave Peterson


--

Dave Peterson

THANKS A LOT

"Dave Peterson" wrote:

Try it. You may be surprised.

LuisE wrote:

Dave,
Thanks for the reply.

What I have listed in the combobox is a range of letter representing, so it
won't fork with integers. The way I wrote the code it works but I can't avoid
the last loop -1

"Dave Peterson" wrote:

dim iCtr as long
for ictr = 0 to cbxaddress.listcount - 1
msgbox cbxaddress.list(ictr)
next ictr


LuisE wrote:

I'm looping thru the items of combobox list, it works fine but at the end
shows an "invalid use of Null" error as if an additional item that can't be
recognized existed.

For Each In CbxAddress.List
MsgBox ccc
Next ccc

Thanks in advance

--

Dave Peterson


--

Dave Peterson