Thread: Input Box
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg B.[_2_] Greg B.[_2_] is offline
external usenet poster
 
Posts: 3
Default Input Box

Dim search1
search1 = InputBox("i.e John Doe", ("WHAT IS THE PLAYERS NAME?"))

Hi all above is my code for an input box.

I have a question about a few things.

How do I get the input box to exit sub when the cancel box or X button is
clicked?

How do I get the inputbox to stay up when the ok button is clicked with no
input in the box?

Thanks for any advise on this issue

Greg B