Thread: Limit range of values for integer
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dksaluki dksaluki is offline
external usenet poster
  
Posts: 48
Default Limit range of values for integer
correction "AND" instead of OR


If i 0 AND <=100 then
* 'do something here
Else
* *MsgBox "Please pick integer in the range of 1-100"
End If

...you could also use a SELECT....CASE block

Reply With QuoteReply With Quote