Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
that's true, i missed that part
-- Gary "Tom Ogilvy" wrote in message ... Easier to check the ListIndex property if x.ListIndex = -1 then x.ListIndex = x.listcount - 1 else msgbox "Item is in list" End if I don't think putting double qoutes on "False" will help since you declared itfits as boolean and not string. -- Regards, Tom Ogilvy "m.s.w" wrote: Gary Keramidas wrote: just a guess, but what happens when you put quotes around true and false? ItFits = "False" Thanks for your advise but it's not the case. It looks, that even when X.Value is eqal to lets say X.List(4) (both values are the same) the "If X.Value = X.List(K) Then..." is not run. Like the values would be not equal. m.s.w |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
if any of 3 conditions is true, then answer is true | Excel Worksheet Functions | |||
Search for 2 true arguments and return true or false | Excel Discussion (Misc queries) | |||
Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
How do I stop Excel from changing the word true to TRUE? | Excel Discussion (Misc queries) | |||
Reverse false and combine with true true value | Excel Worksheet Functions |