Nalla wrote:
Is it possable to capitalize the first letter of an users input as it
is entered into text box that is on a combo box, by useing code
thanks in advance
Another way is to change the text after the user is done typing, like
Private Sub TextBox1_AfterUpdate()
Me.TextBox1.Text = StrConv(Me.TextBox1.Text, vbProperCase)
End Sub
This will change the text to proper case, rather than just capitalizing the
first letter. You may prefer this method if you want to prevent the user
from typing in all caps.
--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com