Display number of records found in a mesage box

Hi All

I have a user form I would like to add a button to that when clicked would display the number of records found.

If I have filters applied to my columns Excel displays the number of records found in the lower left hand corner (see image)

filteredrecordcount.jpg

Can I add this info to a message box, something like this:

Please Login or Register  to view this content.

Thanks for any help you can give

Rich