Case Statement

[realniceguy5000]

I made this case statment below to look at a cell in Q and if the cell value is "Large Area" then the cell in P same row should be 1 if the case is Varsity then it would be 2 however I keep getting a Type Mismatch. I tried Picker.Text and Picker.Value as well I didn't get errors but it didn't work either.

Any Idea's what is wrong?

Thank You, Mike

Please Login or Register  to view this content.

[starryknight64]

Try instead of selecting based on "Picker" to selecting based on "Picker.Cells"

You're selecting on a whole range rather than a particular cell.

I hope this helps!

[romperstomper]

See if this does what you need:

Please Login or Register  to view this content.

[realniceguy5000]

See if this does what you need:

Please Login or Register  to view this content.

Well that worked much better. However I am still having a small problem as I did in my last post with the if then statement. I need to use this line in my code to make the data match up correctly?

Please Login or Register  to view this content.

I'm just curious as to why the rows don't match up? Once I delete P3 then everything is correct.

Thank You for the help...
Mike

[romperstomper]

If it should be the same row, then change both instances of:

Please Login or Register  to view this content.

to just:

Please Login or Register  to view this content.

[realniceguy5000]

If it should be the same row, then change both instances of:

Please Login or Register  to view this content.

to just:

Please Login or Register  to view this content.

Working Now, Thanks so much for the help.

Mike