Worksheet_Change => UserForm => Input Fields into Selected Cell's Row

[kymmeeh]

My first post, but been a big fan of this page for many many years!

I have a UserForm that launches based on a Worksheet_Change to the target inside Column B
After collection 2-3 input fields, I've successfully dropped those inputs into two other sheets.

STUCK because i'd like to use that data into the original Worksheet, based on the selected cell row (into columns B, C, D).

I've tried to pull the active row with multiple attempts, but none have worked..
actrow = ws.UsedRange.Address.Row
actrow = Selection.Row
actrow = Activesheet.Selection.Row

Can anyone help?

 

[kymmeeh]

In trying additional options...finally found one that worked! sharing in case it's helpful for anyone else!
actrow = ActiveCell.row