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]

Please input guys...! I know I have to be more patient....but seriously do you think it is possible???

 

[pedie]

still waiting......

 

[Norie]

Pedie

Please be more patient, bumping so often is not going to speed up any responses.

In fact it might have the opposite effect.

Also please appreciate that the people contributing are from all over the world, therefore you have to consider time differences etc.

As to your actual question, the first thing that sprang to mind for me was why would you want to do such a thing in the first place?

Is there some specific reason you don't want Excel to be displayed/opened?

 

[pedie]

I just want it to open in small window without excel and I want to be able to update information from it to excel file. I thought maybe it is possible!


Pedie

Sorry for bumping

 

[jolivanes]

From Chip Pearson:

Application.Visible = False
UserForm1.Show

Be sure to make Excel visible when you close the form:

Application.Visible = True

 

[pedie]

Hi Jolivanes, thanks for suggesting but how exactly do i post the code and where? and how to go about it....I am not good in all this...

Thanks Pedie

 

[jolivanes]

I have not tried it Pedie but I suggest to Google it as I did.

 

[pedie]

I have googled it...search diff forums...videos channels...etc but i think i'm the first one to think about this

 

[jolivanes]

Googled some more and found this Pedie.
Put it in the This workbook module

Private Sub Workbook_Open()
Application.Visible = False
Userform1.Show
Application.Visible = True
End Sub