View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Minitman Minitman is offline
external usenet poster
 
Posts: 293
Default ComboBox List - Invalid Argument????

Hey Doug,

Thanks for the reply.

I was mistaken on the row (index number). I was coming from row 1
going to row 2.

JLGWhiz brought up an issue that I thought had been addressed quite a
while ago, I just forgot to change the last column in my row source
code (I added a column and missed this one change). It was CB and
should have been changed to CC.

-Minitman

On Sun, 1 Jun 2008 09:54:04 -0700, "Doug Glancy"
wrote:

Minitman,

I don't think this is the answer, but wouldn't row 1 of your combobox have a
ListIndex of 0?

I can't duplicate your problem though.

Doug

"Minitman" wrote in message
.. .
Greetings,

I am trying to set a CheckBox to either true or false depending on if
the value on row 1 column 81 is "X" or empty

I have this statement in a sub:

__________________________________________________ _________
...
If ComboBox1.List(ComboBox1.ListIndex, 80) = vbNullString Then
....
__________________________________________________ _________

That keeps coming up with an invalid argument error. I don't
understand, the elements of the argument appears to be correct.

It's supposed to see if the value on row 1 in the 81st column of the
ComboBox List is empty or not (a checkbox loaded it with an "X" or ""
when the record was created)

Debug shows the value of the ListIndex as 1 which is correct.

Can anyone advise as to where or what could be causing this problem?

Any help will be appreciated.

Thanks for looking at my question.

-Minitman