Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox List - Invalid Argument????
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox List - Invalid Argument????
Does your ComboBox have 80 columns? If the ComboBox1.ListIndex = 1 Then the
statement ComboBox1.List(ComboBox1.ListIndex, 80) would be trying to return the combo box value for row 1, column 80 of the combo box list, not the worksheet. "Minitman" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox List - Invalid Argument????
Hey JLGWhiz,
Thanks for the reply; Good call. I missed one spot when I added an additional column to my source worksheet. I forgot to expand the RowSource from column CB to CC. With your hint I found it and now that section is working again Thanks. -Minitman On Sun, 1 Jun 2008 10:26:00 -0700, JLGWhiz wrote: Does your ComboBox have 80 columns? If the ComboBox1.ListIndex = 1 Then the statement ComboBox1.List(ComboBox1.ListIndex, 80) would be trying to return the combo box value for row 1, column 80 of the combo box list, not the worksheet. "Minitman" wrote: 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox List - Invalid Argument????
Minitman,
That makes sense. That's a lot of columns! If it were me, I might name the crucial column (or the whole area), and have a function in my code to return the column number, and then use that number in the combobox code. Then the next time you add a column your code will still work. cheers, Doug "Minitman" wrote in message ... 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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox List - Invalid Argument????
Hey Doug,
I tried that originally, but the limitations of calling a dynamic named range from a different workbook was causing problems. Due to the size of my customer list (81 columns by 3000 rows) I only had access to the first ~2300 customer in the list. So I defined the range going into the ComboBox RowSource. That is where the oversight occurred. Would you be willing to talk off group about some of the other problems I am having with this workbook rewrite? If so, my email should be visible. -Minitman On Sun, 1 Jun 2008 12:00:50 -0700, "Doug Glancy" wrote: Minitman, That makes sense. That's a lot of columns! If it were me, I might name the crucial column (or the whole area), and have a function in my code to return the column number, and then use that number in the combobox code. Then the next time you add a column your code will still work. cheers, Doug "Minitman" wrote in message .. . 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CreatePivotTable: Invalid procedure call or argument | Excel Programming | |||
Run-time Error '5' - Invalid procedure call or argument | Excel Discussion (Misc queries) | |||
Invalid Procedure Call Or Argument with VBScript | Excel Programming | |||
Invalid procedure call or argument error | Excel Programming | |||
Invalid Procedure call or argument | Excel Programming |