LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 293
Default ComboBox List - Invalid Argument????

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
CreatePivotTable: Invalid procedure call or argument DesertCyclist Excel Programming 4 October 15th 10 03:53 PM
Run-time Error '5' - Invalid procedure call or argument Trefor Excel Discussion (Misc queries) 2 December 17th 07 03:32 AM
Invalid Procedure Call Or Argument with VBScript [email protected] Excel Programming 0 November 28th 07 01:50 PM
Invalid procedure call or argument error Patrick Simonds Excel Programming 1 August 12th 06 11:40 PM
Invalid Procedure call or argument T De Villiers[_58_] Excel Programming 1 July 25th 06 03:01 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"