Userforms are weird. This is how I got it to pop up on top:
UserForm1.Show 0
This loads the form as modeless. That means that the script continues to go
on after the Show command, so you can't treat this like a fancy InputBox
that stop to collect your data and then goes on from there. Instead your
script should end with the Show and the "OK" button on the Userform should
start: the script up again.
Rich McNeil
Boston Software Systems
866 653 5105
www.bostonworkstation.com
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Friday, February 27, 2004 8:33 AM
To: [EMAIL PROTECTED]
Subject: [Talk] Login form
I'd like to write a login procedure for connecting to McKesson STAR that
uses a form to get the userid and password from the user. I want to use VBA
to do this, rather than VB 6, but I can't seem to figure out a way to get
the form to pop up on top of the HBOWEM window. It always comes up behind
it. Is there a way using VBA to do this?
Henry Taylor
Applications Analyst
Lutheran Health Network
Ph. (260) 425-3914
