View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default Create a simple input box

myNum = Application.InputBox("C")

Press ALT-11 to open VBEditor, search for InputBox.

The above will prompt the user with "Enter a number" and store the response
in the variable myNum.

"Marilyn" wrote:

Hello How do I create input box asking the user to type in the term of
agreement
1, 2, 3, 0r 4 years
or where can I get instructions to do this. I have a book but the
instructions are not very clear to me. thanks