Name box to get active cell

Hi all
I am trying to work out a VBA formula for a command button to get the active cell from the NameBox and use it to find the next blank row below that range

example active cell in NameBox is M224 Rows B 225, B226 ,B227 have data then it would go to B228 as the first blank row
when I push the command button

the object to do the above is to close Userform 2 and open userform 1

thanks for any help

You can get the next blank row using something like this, or are you saying that there will be blank rows after the activecell but before other data?
Not sure where the userforms fit in with this either?

Please Login or Register  to view this content.

I have a userform that gets data from a open work sheet I would like on save' userform to write a txtbox value back onto the sheet
sheet on the same row as the userform the data came from below is the code but I get error on the offset =Txtyes
Also I have attached a sample work sheet Any help Please and Thanks

Please Login or Register  to view this content.

... something like that ?

Please Login or Register  to view this content.