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

pedie

Well-known Member
Joined
Apr 28, 2010
Messages
3,875
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;)
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

pedie

Well-known Member
Joined
Apr 28, 2010
Messages
3,875
Please input guys...! I know I have to be more patient....but seriously do you think it is possible???
:biggrin:
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,344
Office Version
  1. 365
Platform
  1. Windows
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

Well-known Member
Joined
Apr 28, 2010
Messages
3,875

ADVERTISEMENT

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!

:biggrin:
Pedie

Sorry for bumping;)
 

jolivanes

Well-known Member
Joined
Sep 5, 2004
Messages
1,927
Office Version
  1. 2013
  2. 2007
Platform
  1. Windows
From Chip Pearson:

Code:
Application.Visible = False
UserForm1.Show

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

Code:
Application.Visible = True
 

pedie

Well-known Member
Joined
Apr 28, 2010
Messages
3,875

ADVERTISEMENT

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

Well-known Member
Joined
Sep 5, 2004
Messages
1,927
Office Version
  1. 2013
  2. 2007
Platform
  1. Windows
I have not tried it Pedie but I suggest to Google it as I did.
 

pedie

Well-known Member
Joined
Apr 28, 2010
Messages
3,875
I have googled it...search diff forums...videos channels...etc but i think i'm the first one to think about this:biggrin:
 

jolivanes

Well-known Member
Joined
Sep 5, 2004
Messages
1,927
Office Version
  1. 2013
  2. 2007
Platform
  1. Windows
Googled some more and found this Pedie.
Put it in the This workbook module

Code:
Private Sub Workbook_Open()
Application.Visible = False
Userform1.Show
Application.Visible = True
End Sub
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,836
Messages
5,833,903
Members
430,241
Latest member
Matty Se

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top