you can make a userform that fullfils your needs.
use:
to show the form
put u commandbutton on the form to close the form
put the following code in the commandbutton click event:
Sub Command1.Click
UserForm1.Hide
End Sub
The textbox properties are still readable after this.
Now you can read the values from the forms textboxes:
Dim sAnswer as String
sAnswer = Userform1.Textbox1.Text
etc.
after that you can unload the form:
The textbox properties are lost after this.
Reputation Points: 10
Solved Threads: 5
Junior Poster in Training
Offline 60 posts
since Mar 2007
Unsolved 
