Transfer Data from excel to userform

Hello

is it possible to select a cell (by clicking on it) and then click on the button and transfer that row's data to userform?

How about

Private Sub UserForm_Initialize()
   With ActiveCell.EntireRow
      Me.TxtID = .Range("A1")
      Me.TxtFirst = .Range("B1")
      Me.TxtLast = .Range("C1")
   End With
End Sub

Originally Posted by Fluff13

How about

Private Sub UserForm_Initialize()
   With ActiveCell.EntireRow
      Me.TxtID = .Range("A1")
      Me.TxtFirst = .Range("B1")
      Me.TxtLast = .Range("C1")
   End With
End Sub

Thank You

Originally Posted by Richard Buttrey

Hi,
One way would be to use the form's Initialise event. i.e.

Private Sub UserForm_Initialize()
    Me.TxtID = Range("A" & ActiveCell.Row)
    Me.TxtFirst = Range("B" & ActiveCell.Row)
    Me.TxtLast = Range("C" & ActiveCell.Row)
    
End Sub

Depends what you are trying to achieve.
You might like to consider instead of text boxes using List or ComboBoxes so that they contain all relevant values so that you can pick one. You can load the values by either using the .RowSource property of the control objects or the .AddItem code syntax

Thank you
The userform I made has multiple combobox and textbox and i'm using this for editing the table.

Glad to help & thanks for the feedback.