Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Josefina Stanley   on Sep 20 In MS Office Category.

  
Question Answered By: Chaths Massri   on Sep 20

You will need to make a userForm with the three textboxes on it. (and a label
telling the user  what to do). Also include two buttons one for OK and one for
cancel.

Declare (Dim) the three variables outside the sub so they are available to
both the sub and the form

In the sub put Userform1.show

In the form code  for the OK button put code to set each of the three variables
equal to the textboxes on the form
Then put

Unload me

Also put unload me in the sub for the cancel button (you might need to put
some more code to handle errors, cancellation etc)


Share: 

 
 
Didn't find what you were looking for? Find more on If not found then data entry Or get search suggestion and latest updates.


Tagged: