Call a commandbutton click event from a module

Hi ALl

I have a module and I want to call commandbutton1_click event of a userform from a module. The following code give me error:

Please Login or Register  to view this content.

ANy help will be much appreciated.

Thanks

Good afternoon aman1234

You're halfway there making your CloseMe sub public - but it's the wrong one

Userform Code:

Please Login or Register  to view this content.

Module Code:

Please Login or Register  to view this content.

HTH

DominicB

I tried it but it says method or data memmebr not found.

Hi aman1234

This seems to work fine on Excel 2007.

HTH

DominicB

Edit : Your profile says you are using Excel 2003. Do I need to resave in another format, or do you need to update your profile?