I have a user form where the user enters a site number. in the spreadsheet i have a range names "ValidSites".
After the user enters a site number and clicks on a button, i would like to validate that that site appears in the ValidSites list.
onclick event()
if txtSiteNumber is found in Range(ValidSites) then
msgbox("found")
else
msgbox("notfound")
endif
endsub
what would be the code for the if statement?
thanks in advance
Bookmarks