Activate entire row, of selected cell

[Et3rnal]

The user will be selecting a cell, and then use a hotkey to bring up a userform. I want VBA to activate the entire row of the cell selected by the user.

I'm able to activate every row of the worksheet, as well as rows based off number inputted into cells, but the row of the selected cell is beyond me. Any advice?

[lasw10]

Private Sub Worksheet_SelectionChange(ByVal Target As Range) 
    Rows(Target.Row).Select 
End Sub 

[iwrk4dedpr]

Or

activecell.entirerow.select 

Regards,
Barry

[Dave Hawley]

Hi Et3rnal

The code below will do this;

Private Sub UserForm_Initialize() 
    ActiveCell.EntireRow.Select 
End Sub 

[Et3rnal]

Works great, thanks guys