Re: Userform to appear on top?

Tech-Archive recommends: Speed Up your PC by fixing your registry

Once again thanks very much Dave, I used the code.
--
capt


"Dave Peterson" wrote:

Put a label on the form with the textbox with instructions--or better yet, just
make the string uppercase before you process it.

mycell.value = ucase(me.textbox1.value)

And let the users do whatever they want.

capt wrote:

I cant seem to make it work.
There may be another way.
In my userform1, the users will write their names in textbox1. I was after a
note to explain that the name are to be in upper case.
Any Suggestions?
--
capt

"Rick Rothstein (MVP - VB)" wrote:

Do you really need another UserForm to do that? What about using a TextBox
(with both the Locked and MultiLine properties set to True) on UserForm1
instead? You could then use Initialize event code similar to this for
UserForm1...

Private Sub UserForm_Initialize()
TextBox1.ZOrder
'....
'.... Your intialize code goes here
'....
TextBox1.Visible = True
End Sub

You can then dismiss the TextBox whenever you want elsewhere in your code
like this...

TextBox1.Visible = False

To make the TextBox stand out, you can set it BackColor property to, say, a
very pale yellow, its BorderStyle property to 1-fmBorderStyleSingle and its
BorderColor property to, say, a dark red.

Rick


"capt" <capt@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FC710FFC-3029-4A40-B440-563DDA2BE34F@xxxxxxxxxxxxxxxx
Thanks Jim,
I was after for userform7 to appear automatically when userform1 was
opened.
The idea is to show operating notes to the users when its opened.
--
capt


"Jim Cone" wrote:


Add a button on UserForm1 with code to show UserForm7
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"capt" >
wrote in message
How do I get a userform7 to appear on top of userform1 when userform1 is
opened.
I have the following code:

Private Sub CommandButton1_Click()
UserForm1.Show
End Sub
--
capt




--

Dave Peterson

.

Quantcast