Form on the first row of the sheet

[saravnepali]

Is it possible to have a userform always on the first row of the sheet
Ie if the cells are hidden or scroll the form will be displayed accordingly

And width equal to the width of the excel application window
Aim is to display current workbook status every time on the top of the sheet
Like doing a freeze pan but data updates quickly and applicable for all sheets on the workbook

[kev_]

This may help
http://www.cpearson.com/excel/FormPosition.htm

[saravnepali]

Thanks Kev

This tells us where to put the form

Is there any way to find the coordinates of the cells that are currently visible

[kev_]

Code below works for me - I did nothing other than paste it into my module

Not my code - found it here
https://www.mrexcel.com/board/thread...-range.765416/

To test if it, paste everything into a new module and run GetCoordinateTopLeft

Please Login or Register  to view this content.

---------------------------------------------------------------------------------------------------------------
If you encounter a problem it may be down to the version of VBA on your machine not being 32bit
This will tell you ...

Please Login or Register  to view this content.

And (according to the link above) for Win64 version of vba ...
Put Private PtrSafe instead of Private

I cannot help you resolve anything with this code - it is way over my head!

[saravnepali]

Thanks Kev for your help.