closing forms 1

[uscitizen]

i'm a newbie wrt vba and w/ that said....

i have a bunch of forms and while i could create a bunch of macros each of which would be written to get triggered to close a form when a command button atop the form's 'clicked' i have a sneaking suspicion that some 'function' could be written and made 'universal' (if that is the proper term) that could be activated to 'close the current form' when the command button's clicked. i'm looking to use one function without having to expressly name the form it's going to close. sound doable?

 

[xlbo]

well, you can use the keyword "Me"
as in
me.hide
me.unload
BUT
it will not work outside of the userform module that holds the code for that particular userform so, we have to pass the form object thru the sub

In a standard module:

Sub Closer(frm As Object)
frm.Hide
End Sub


in the code for the button that closes the form:
call Closer(me)

HTH

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[uscitizen]

thanks!
i just 'discovered' the command button wizard which seems to let you interactively pick from a small collection of functionalities what you'd like your button clicking to do.

i would like to learn more wrt vba though (as i doubt i'll be quite as fortunate in every quest) and there's no shortage of 'good' books -- problem is there's too many.

decisions, decisions...

 

[xlbo]

Well, I have never extensively used a reference book for VBA - I just use the help files, the object model, this forum and an excel developers mailing list that I am subscribed to. That said, the one that crops up a lot is John Walkenbach's power programming series

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[uscitizen]

Thanks again