View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
If[_3_] If[_3_] is offline
external usenet poster
 
Posts: 6
Default Populate TextBox with other textbox value

Hello Isabelle,

Big Thanks to you.

Yves


hello Yves,

Private Sub UserForm_Initialize()
Dim sUserName As String, x As Integer
sUserName = Environ("username")
With Sheets("Users")
If Not IsError(Application.Match(sUserName, .Range("A:A"), 0)) Then
x = Application.Match(sUserName, .Range("A:A"), 0)
TextBox1 = .Range("A" & x)
TextBox2 = .Range("B" & x)
TextBox3 = .Range("C" & x)
End If
End With
End Sub