This method hides the UserForm from the display. Another method is when we use Useform.Hide method.This method unloads the UserForm and it disappears from the display. The first method is when we use the Unload Me method.Now there are two methods by which we can hide a userform. The cancel button also has its own code to hide the userform from the user. Similar to submit button to submit the data we had another button which was for cancel which is used to hide the userform. We had not discussed how we will close the userform for the user. Or what if the user does not want to give any data and close the userform. But what after giving the value the form is still there. Now to get input from the user there was a button for submit, which stored then the value given by the user in an excel sheet. Earlier we had discussed how to create a UserForm in VBA.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |