Tech Support Forum banner
Status
Not open for further replies.
1 - 5 of 5 Posts

·
Registered
Joined
·
8 Posts
Discussion Starter · #1 ·
Hi Friendly Supportive People

I have a simple template that has the code below. I would like to know how to make the value of the text entered into the member text box all caps, even if the user types initial caps in the Userform text box. Thanks for the assistance.

With ActiveDocument
.Bookmarks("member").Range.Text = txtmember.Value
.Bookmarks("balance").Range.Text = txtbalance.Value
.Bookmarks("status").Range.Text = txtrstatus.Value
End With
 

·
Moderator , Microsoft Support, MS Office Pro
Joined
·
2,540 Posts
Try:
Code:
With ActiveDocument
  .Bookmarks("member").Range.Text = UCase(txtmember.Value)
  .Bookmarks("balance").Range.Text = UCase(txtbalance.Value)
  .Bookmarks("status").Range.Text = UCase(txtrstatus.Value)
End With
 
1 - 5 of 5 Posts
Status
Not open for further replies.
Top