Userforms Show Data from specific ROW dynamically (and perform Date arithmetic)

Hello Seniors,

I Have a Worksheet, wherein ROW 8 acts as header. Data range would vary say a9:az10000 or so. (dynamic data range keeps expanding / contracting).
Data range could be Filtered (hidden row) or Unfiltered.

Depending on Row Number specified by a User in USER-FORM, USER-FORM should automatically populate / display key data from relevant Row from corresponding Column.

Say, When Userform is Loaded, User has to Key-in Row Number, say Row # 22

Terminal Date (Textbox) = C22 (DATE FORMAT IDEALLY, DD-MMM-YY)
Time Date (Text box) = O22 (DATE FORMAT IDEALLY, DD-MMM-YY)
DIFF (TEXTBOX) = C22-O22 (NUMBER OF DAYS, numeric)
TARGET (TEXTBOX) = TIMEDATE(O22) + DIFF = DERIVED DATE (DATE FORMAT IDEALLY, DD-MMM-YY)

IDENTIFIER = B22
Label H4 = I22
Label FWD = P22
Label EXPECT = Q22
Label PEP =R22
Label PED = S22

Likewise, once I get basic code for above sample, I will make other Text Labels and Textbox to populate / fill required data from Column X to Column AZ for display purpose on User-Form, depending on requirements.

Once Row Number is changed, if possible, without unloading form everything should change consequentially.

Please Note that above displayed (Specific row) data would then be subject to further calculation on same form, as and when my work expands.

Sample workbook is attached.

In the given workbook, I am able to populate required data from ACTIVE ROW using following code, except ROW Number.

Please Login or Register  to view this content.

Now require guidance from learned seniors .

In above code, limitation is that, it will populate data from active row only. While USERFORM is in use, I can not change ACTIVE ROW. So, How to read ROW Number in first Textbox, take it as variable and assign to ROW number and populate /change data accordingly, based on ROW number.

I trust, it is doable. Thanks. Since,I have changed couple of Textbox Caption, and Code is built accordingly, I am appending the sample workbook again here.

Other Clue, from Properties Window, I set ShowModal = False. I am able to change row and scroll spreadsheet. By changing ROW my USERFORM still shows old data only, so, how to take this hint to update /populate data record from changed ACTIVEROW, if this could be easier, i can drop idea to have ROW Number on Userform to populate data. Can this be done through Event ? How?

I am near to solution, if someone can guide suitably, please. Thanks

Got it, I just added one Commandbutton, and added code to UNLOAD and SHOW UF to get it update from changed ACTIVEROW.

First time, raised the query and through learning solved also :D

Nonetheless, would appreciate some other better alternate.

Would still love to know, how to put manually ROW Number on USERFORM, pass it on this ROW Number to some variable and change ACTIVE ROW accordingly.