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;)
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

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
75,765
Office Version
365
Platform
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,593
Office Version
2013, 2007
Platform
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,593
Office Version
2013, 2007
Platform
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,593
Office Version
2013, 2007
Platform
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
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,747
Messages
5,513,153
Members
408,939
Latest member
jessica116

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top