Search results for query: *

It was UserForm that I needed. Thanks for the help and here is my oh so simple solution Private Sub btnCancel_Click() Call cancelButton(Me) End Sub Sub cancelButton(frm As UserForm) Unload frm End Sub

I am trying to create a sub procedure for cancel buttons across several forms. The problem is that I need to be able to pass the form object to the procedure in order to unload the form. Can anyone help?

BTW, Yes, the user enters the different data being compiled from a paper report.

Thanks guys I will use some of your examples as soon as I get the chance however I have been sidetracked on a different project for the moment.

I was wondering if anyone know of a way to enter information from one form onto another form. The situation is thus: I have a main form with textboxes on it however one text box is a compilation of several numbers, so I created another form in order enter in those numbers. I then pass this...

The problem was that I had used day as a variable and so it confused the compiler. It is being written for Excel but I am writing in the VBE.

This DAY function doesn't seem to be recognized by my version of Office, 2003. It won't compile at all.

nevermind I used datepart instead

I'm not sure how that works could you give me an example of how the DAY function is used? The VBA help file seems to be worthless on this subject.

Does anybody know how to extract just the day from a date because the month and year don't matter to me.