View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default ComboBox problem

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