A AlexLim Joined Nov 15, 2011 Messages 7 Reaction score 0 Dec 27, 2011 #1 I want when user type a value that not in the list will not only show error message but also can run other function like direct too another worksheet or other else No matter using validation function or with other code, thk =)
I want when user type a value that not in the list will not only show error message but also can run other function like direct too another worksheet or other else No matter using validation function or with other code, thk =)
A AlexLim Joined Nov 15, 2011 Messages 7 Reaction score 0 Dec 28, 2011 #2 I found the way already, thk If Range("K5").Validation.Value = True Then it validate the value is in list or not and allow me do other task in if else Kind of crazy answer my own question
I found the way already, thk If Range("K5").Validation.Value = True Then it validate the value is in list or not and allow me do other task in if else Kind of crazy answer my own question
A AlexLim Joined Nov 15, 2011 Messages 7 Reaction score 0 Dec 28, 2011 #3 By the way, anyone can tell me how to mark post solved?