View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg[_30_] Greg[_30_] is offline
external usenet poster
 
Posts: 1
Default Help with code please

Hi I am just wondering how to change the code below. I have an input box ask
for a amount and it has to be between 0 - 8 how do i change the code to do
this. I need it to tell a message that is an amount that is too much and
reload the input box. Here is the code

Dim ALL1 As String
ALL1 = InputBox("HOW MANY PEGS DID " & N1.Caption & " GET IN THE DOUBLES?",
"ALL SECTION.", 0)

Thanks

Greg