Marcs

hi
i wonder if there is a way to get the name of the active userform in another macro
i have a userform and when i click a commandbutton it runs a macro(application.run)
this macro adds a new sheet and i want the sheets name to be the name of the userform but i dont get it
i think i have to make the name of the userform public so that the macro can use the variable
or get the userforms name with the macro code but i cant
any solutions?

Timbo

strNewWorksheetName = Me.Name

Marcs

thanx for your reply timbo
but its not what im looking for
the new sheet (added from a macro in a modul) should have the name of the Form
and because its a seperate macro the variables defined by the form are deleted and the form is inactive so that i cant use Me

Timbo

If the procedure is launched from a command button on the form, you can pass the variable to it. Look up the 'Sub' statement in your VB Help...

Marcs

Quote:

---

Originally Posted by Timbo
If the procedure is launched from a command button on the form, you can pass the variable to it. Look up the 'Sub' statement in your VB Help...

---

ive looked there but i saw nothing helpful
i try to describe my problem a better way


i have a userform with a commadbutton
if i click on the commandbutton
a procedure is been launched
(to insert several data into a sheet)
and this sheet has to be created first
this should happen by a macro (in a modul[like you use the macrorecorder])
and this macro is launched by a line in the procedure
(with Application.Run "macro")
and because of this i cannot use the variables i define in the procedure
and i cannot access the userform from the macro
but i need the name of the userform because the new sheet should have the same

hope it is more clearly

MJMJ

This might work--
Before you run the macro, open the new application and set the caption of the application window with the same name as the form.
Then in the macro you call, use application.caption to get the name.

or, open the application and create and name a new document or worksheet before running the macro in that application.

-MJMJ

Marcs

its a bit long winded but it works
thanx mjmj