#CLOSE VLC WITH VBA IN EXCEL 2016 HOW TO#

Now let us try the second method which userform.hide method in a similar fashion as above, first, let us open the userform from the userform in the project window. Press Cancel button to see that the userform disappears and it takes us back to the original userform of the project window. Now let us run the userform by pressing the F5 key to display it. We can see that Me is an Object of Unload statement. But when we use the second method of hiding the UserForm, then the last entry done on the userform by the user is still present. It is recommended to use the second method to close the UserForm as the first method will completely unload the UserForm and any data entered by the user will be completely lost. 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.

#CLOSE VLC WITH VBA IN EXCEL 2016 HOW TO#

Earlier we had discussed how to create a UserForm in VBA.

Close vlc with vba in excel 2016