Active row always visible macro

[Philb1]

Hello..
Is there a way of making the active row visible when data is being entered via a userform?
The worksheet is split vertically (Not by split feature in Excel) & the data is entered in one side or the other of the sheet, depending on userform selections. If the data on one side is below the bottom of the screen, you can't see if the entries are being made. For visual conformation it would be good if the active row was always in the middle of the screen. When making multiple entries the userform stays onscreen, but the rows that are out of sight can't be got at because the scrollbar is locked. Approximately the top 1/3 of the screen is frozen, the sheet protected & all cells locked. The macro un protects it, enters the data & re protects it. It's that way, to stop them stuffing it up by deleting in the wrong columns & deleting formulas as well etc. There's another macro for delete.
Any ideas on that one??
Thanks

[pike]

Hi Philb1
Do you mean something like

Please Login or Register  to view this content.

[Philb1]

Hello Pike.. I figured it out

Please Login or Register  to view this content.

Works for the right side
Changing the J to a C & the -2 to 5 make it do what I want for the left side of the sheet.
Thanks for the reply
Phil

[Philb1]

Its most likely the way in which I tried to describe what I wanted it to do. Clear as mud. You'd need an Enigma to decypher it lol

[pike]

strange but i did understand the regional use of english