View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jeff jeff is offline
external usenet poster
 
Posts: 48
Default Upper case 1st letter only

This is for when the value of a textbox is pasted.
I know that
Application.Selection.Value = UCase(TextBox2.Text)
will result in all caps. Is there a variation of the code that will
result in just the1st letter being in caps?
I searched but could not find any reference to this.
Thanks
jeff