View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
mudraker[_35_] mudraker[_35_] is offline
external usenet poster
 
Posts: 1
Default Using VBA functions in Worksheet cell data validation


Function IsValid(Num As Variant) As Boolean
select case num
case 0 to 100
isValid = true
case else
isValid =false
end select
End Function


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/