List Box help~~

A

AlexLim

Joined
Nov 15, 2011
Messages
7
Reaction score
0
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 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 :lol:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a drop down list in Excel with 2 different work sheets 3
SUMIF, use List as a Range 2
Short listing the Data Validation List 2
stumped on creating dependent data validation lists 1
Urgently help needed - dropdown box does not show up 1
Excel VBA 1
validation list 6
Can the source in data validataion be located in another sheet? 2

Back
Top