Clicking on cell to go to VBA user form

[VBAmalta89]

i have created a VBA user form which will send the data inputted in it to a worksheet on excel.

Is it possible to use VBA so that when the user needs to edit the data all he needs to do is click on any cell in the worksheet that contains data from the user form?

I am new to VBA so Im sort of clueless

 

[pbornemeier]

You could capture a selection change, right-click or double-click on cells using a worksheet event, then populate the userform with the data that the clicked on row contained.

Put the following code on the codepage of the worksheet that should be monitored:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Dim rngDataRange As Range
 
    Set rngDataRange = Range("A1:F500") 'Enter range(s) that should be monitored
 
    If Target.Cells.Count > 1 Then GoTo End_Sub 'ensure only 1 cell
    If Not Intersect(Target, rngDataRange) Is Nothing Then
        Application.EnableEvents = False 'Prevent following code from triggering events
        'Code to do what is desired when
        Debug.Print Target.Row, Target.Address 'for debug & demo
    End If
End_Sub:
    Set rngDataRange = Nothing
    Application.EnableEvents = True
End Sub