Good morning,
Can anyone see what is wrong with my code? I am using the name identified in the combobox (cmbPS) to identify the row and then change the resulting cells. I keep getting an application defined or object defined error highlighting the row markedThe entire code:
Please Login or Register to view this content.
ThanksPlease Login or Register to view this content.
M
Any ideas?
PArtially fixed using the following code:
Problem now is that it's updating the right columns but the wrong rows. Is my cmbPSListIndex + 7 incorrect in defining the row of the selected value from the combobox (the list starts 7 rows down on the spreadsheet)?Please Login or Register to view this content.
Any ideas?
Hi ! Can't you upload a sample file? (after striping off the sensible data)
.. and don't forget to have fun!
Bogdan.
mark SOLVED andAdd Reputation if my answer pleases you
Sorry I can't post the file, I think it has something to do with this line being incorrect:
Please Login or Register to view this content.
there is a dot missing there...
if that is the error it should be
if not, try to find the cmbPS.ListIndex valuePlease Login or Register to view this content.
put a msgbox cmbPS.ListIndex before that line. (debug.print cmbPS.ListIndex works also if you have the Immediate Window enabled (Ctrl+G)
OK I fixed that but for some reason it's still changing the incorrect rows.
Ok I pinpointed the issue, it's because cmBPS is creating unique values from PSList which has duplicate entries:
As a result, cmbPS.ListIndex is not equal to PSList.ListIndexPlease Login or Register to view this content.
How should I go about fixing this?
i have no ideea untill i see the entire code BUT you can try :
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks