I need some assistance with excel 07 USERFORM, please help! in poping it up independently...

[pedie]

Can the userform in excel be independent....?
What I mean is can i make the userform to appear without opening the excel file or even if we use to open it can it not show but just the userform???
Is there a way to set it? I want it to pop up like any other software thing when i put the path in my startUp.

I have a userform and the code that functions but i want to know if the userform can just pop up by itself and independently work with having to open or show whole excel file??? or maybe make that particular excel file hide somewhere when it pops up???something like that???

Please advice!
Thanks alot in advance!

Pedie

 

[pedie]

Jolivanes..thanks ahlo....t!!!

Lemmi give it a try...
Maybe if you can also share me the link that where you based this idea it will be great if u can u know paste it here....if that is allowed...

Okay thanks alot again!

 

[pedie]

Wow...it worked...GREAT!!!
Thank you a million times....

I'll add some more code maybe be so that as soon as i click on the userform after filling out the info..it just goes away...without showin the excel sheet....

Coooool!

Thanks again!
PED

 

[jolivanes]

I don't have the link anymore but I think it was from Tom Ogilvy (might have spelled his name wrong here)
However, if you google it, you're bound to find it.
Use this to google: Application.Visible = False+Userform1.Show
HTH
John

 

[Norie]

Pedie

Believe me you are not the first person to ask about this sort of thing.

When you were searching did you find any references to Windows API?

That's one approach that can be used to work with windows/forms and not just with Excel.

Mind you the code involved isn't that straightforward and might actually be considered a bit scary.

 

[pedie]

Norie, thanks.

Thanks everyone for helping!