Code:Private Sub Worksheet_SelectionChange(ByVal Target As Range) Rows(Target.Row).Select End Sub
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?
The code below will do this;Code:Private Sub UserForm_Initialize() ActiveCell.EntireRow.Select End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)