View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FARAZ QURESHI FARAZ QURESHI is offline
external usenet poster
 
Posts: 553
Default A simple inputbox & responding msgbox coding

I sure woul oblige for the simplest piece of code for an inputbox as:

"Enter Your Name"

1. If nothing is entered and OK is pressed:
msgbox("Nothing has been entered. Please RETRY")

2. If Cancel is pressed:
msgbox("You have cancelled the operation")

3. If something is entered and OK is pressed:
msgbox("You are " & Nme)

I have also found that codes do not work similarly enough in respect of the
TYPE of the inputbox to be Text or Cell Reference/Range Based, i.e. for
Type:=2 or Type:=8 any reference for relevant material on net.

Thanx in advance.