View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JMay JMay is offline
external usenet poster
 
Posts: 468
Default InputBox Question

The InputBox allows for a Title parameter Where you can instruct the user to
Not enter over 8 text characters (say), but additionaly put in a line of code
following the Inputbox line, somthing like..

ans = Incputbox("Enter proper text - Limit to 10 Characters..")
if Len(ans) 10 then
Msgbox "Too many characers, limit to 10 or less"




"Les Stout" wrote:

Hi all, is it possible to limit the number of text put into an input box
?

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***