User Form Show
 

With the generous help of Dave Peterson I created a small applet in
excel 2003, really it is a simple calculator used for a specific job,
nothing is saved or carried forward anywhere, and when I have the
numbers I need, I simply close the app until I need it the next time.

What I would like to know is if there is a way that I can show my user
form without excel showing on the screen in the background, maybe open
excel in a minimized state? To open excel in a minimized state ONLY when
I use this app, where would I put that code? I am going to create a
desktop shortcut to the app - would the code to open minimized go at the
end of the path in the properties of the shortcut? or do I need some
sort of autoexec.bat file somewhere to do this?
As you can tell, I am pretty new to Excel VBA, but I sure find it kind
of an interesting thing to puzzle out.
Thanks for your help
Joanne

User Form Show
 

Try this before you load your form:

Application.WindowState = xlMinimized


RBS




"Joanne" wrote in message
...
With the generous help of Dave Peterson I created a small applet in
excel 2003, really it is a simple calculator used for a specific job,
nothing is saved or carried forward anywhere, and when I have the
numbers I need, I simply close the app until I need it the next time.

What I would like to know is if there is a way that I can show my user
form without excel showing on the screen in the background, maybe open
excel in a minimized state? To open excel in a minimized state ONLY when
I use this app, where would I put that code? I am going to create a
desktop shortcut to the app - would the code to open minimized go at the
end of the path in the properties of the shortcut? or do I need some
sort of autoexec.bat file somewhere to do this?
As you can tell, I am pretty new to Excel VBA, but I sure find it kind
of an interesting thing to puzzle out.
Thanks for your help
Joanne

User Form Show
 

You could also hide excel:

Application.visible = false
'show the form
application.visible = true

But then the user would be looking at a different application (or the desktop).
And if the user had another workbook open and wanted to see that, it might be
disconcerting--well, depending on how you showed the userform.

Joanne wrote:

With the generous help of Dave Peterson I created a small applet in
excel 2003, really it is a simple calculator used for a specific job,
nothing is saved or carried forward anywhere, and when I have the
numbers I need, I simply close the app until I need it the next time.

What I would like to know is if there is a way that I can show my user
form without excel showing on the screen in the background, maybe open
excel in a minimized state? To open excel in a minimized state ONLY when
I use this app, where would I put that code? I am going to create a
desktop shortcut to the app - would the code to open minimized go at the
end of the path in the properties of the shortcut? or do I need some
sort of autoexec.bat file somewhere to do this?
As you can tell, I am pretty new to Excel VBA, but I sure find it kind
of an interesting thing to puzzle out.
Thanks for your help
Joanne

--

Dave Peterson

User Form Show
 

Thank you, I will give this a try asap
Might I ask another question?
I am wondering how I make my command button respond to the enter key
when it is active, so that I don't have to reach for the mouse to get
the calculation.
Your interest in my questions is very appreciated
Joanne

RB Smissaert wrote:

Try this before you load your form:

Application.WindowState = xlMinimized


RBS




"Joanne" wrote in message
...
With the generous help of Dave Peterson I created a small applet in
excel 2003, really it is a simple calculator used for a specific job,
nothing is saved or carried forward anywhere, and when I have the
numbers I need, I simply close the app until I need it the next time.

What I would like to know is if there is a way that I can show my user
form without excel showing on the screen in the background, maybe open
excel in a minimized state? To open excel in a minimized state ONLY when
I use this app, where would I put that code? I am going to create a
desktop shortcut to the app - would the code to open minimized go at the
end of the path in the properties of the shortcut? or do I need some
sort of autoexec.bat file somewhere to do this?
As you can tell, I am pretty new to Excel VBA, but I sure find it kind
of an interesting thing to puzzle out.
Thanks for your help
Joanne

User Form Show
 

how I make my command button respond to the enter key when it is active

When a commandbutton has the focus it should respond to the Enter key the
same as if it was clicked.
If that is not the case in your situation then I think you must have added
some code to prevent this.

RBS

"Joanne" wrote in message
...
Thank you, I will give this a try asap
Might I ask another question?
I am wondering how I make my command button respond to the enter key
when it is active, so that I don't have to reach for the mouse to get
the calculation.
Your interest in my questions is very appreciated
Joanne

RB Smissaert wrote:

Try this before you load your form:

Application.WindowState = xlMinimized


RBS




"Joanne" wrote in message
...
With the generous help of Dave Peterson I created a small applet in
excel 2003, really it is a simple calculator used for a specific job,
nothing is saved or carried forward anywhere, and when I have the
numbers I need, I simply close the app until I need it the next time.

What I would like to know is if there is a way that I can show my user
form without excel showing on the screen in the background, maybe open
excel in a minimized state? To open excel in a minimized state ONLY
when
I use this app, where would I put that code? I am going to create a
desktop shortcut to the app - would the code to open minimized go at
the
end of the path in the properties of the shortcut? or do I need some
sort of autoexec.bat file somewhere to do this?
As you can tell, I am pretty new to Excel VBA, but I sure find it kind
of an interesting thing to puzzle out.
Thanks for your help
Joanne