Add Data then close userform

[Cruizer67]

How can I get it to close the window(userform) after taking the information and adding it to the spread sheet.. as it is now I have oit so that they have to press the close buttom..

This is the add button

Private Sub Add_Click() This adds the info of course..

after that they have to press this to close userform..

Private Sub Cancel_Click()
Unload Me
End Sub


I'd like to close the userform automatically after pressing the add button and it inputs the data

any ideas please?

 

[Von Pookie]

Add the Unload Me line to the end of your Add_Click code.

 

[Smitty]

Just put Unload Me after the code that adds the data to the sheet in your Add_Click code.

You may still want to leave the close button in case someone doesn't want to update at that time.

HTH,

Smitty

 

[Cruizer67]

Great Great Great ...

simple pleasures of life huh...

Thanks