text boxes in forms

[hainejo]

Is there a way to format text boxes in a form so that text that is entered is always in upper case?

 

[Mark O'Brien]

What type of form? A VBA userform? Or have you got the textbox on a spreaadsheet created from the "Drawing" menu or the "Controls" menu or something?

The answer is probably "yes and no". dependant on what type of textbox we're talking about here.

 

[hainejo]

It is a VBA form

 

[Mark O'Brien]

Excellent, here's a pretty simple way to accomplish this, suppose my textbox is called "TextBox1", I would put this code on the userform in the Textbox1 "Change" event:

<pre>
Private Sub TextBox1_Change()
Me.TextBox1.Text = UCase(Me.TextBox1.Text)
End Sub</pre>

HTH

 

[Mudface]

Try something like: -

Private Sub TextBox1_Change()

With TextBox1
    .Text = UCase(.Text)
End With

End Sub

Edit: oops, sorry, you in 'stealth' mode?
This message was edited by Mudface on 2002-08-20 12:52

 

[Mark O'Brien]

Edit: oops, sorry, you in 'stealth' mode?
This message was edited by Mudface on 2002-08-20 12:52

Sometimes. I'm just posting these days when the urge strikes me.

On a side note, I talked to a friend yesterday that had spent over a year in Hull doing some contract work for BP, she claimed that it was not, in fact, sunny. She also disagreed with the fact that anything useful came from or resided in Hull. (I proffered "The Housemartins".)

 

[hainejo]

That did the trick! Thanks!

 

[Mudface]

On 2002-08-20 12:57, Mark O'Brien wrote:

Sometimes. I'm just posting these days when the urge strikes me.

On a side note, I talked to a friend yesterday that had spent over a year in Hull doing some contract work for BP, she claimed that it was not, in fact, sunny. She also disagreed with the fact that anything useful came from or resided in Hull. (I proffered "The Housemartins".)

I think I'd be banned from the board for an accurate description of Hull in my profile...