Closing a User Form

[TheEntertainer]

Hi,

I've added a command button to a user form what code can I use to close the form once the command bar is click and leave the excel sheet still open

Thanks

 

[Guest_imported]

quite simple:

sub cmdExit_click()
me.hide
End sub

cmdExit = the button

 

[Guest_imported]

that will leave the form loaded btw. just hidden
if u want it unloaded then

sub cmdExit_click()
unload me
End sub