Locate ShowDataForm on Screen

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to open a ShowDataForm in the Top Left hand corner, right over
the menu items (ie file, print etc). We're trying to use a scanner for input
and it can only see the very top left of a worksheet. Unfortunately every
time we open the Form it appears in a different screen location.
Thanks
 
I don't know of any way to open the data form in that position.

John Walkenbach has an enhanced data form that opens with the record of
the active cell. You can download a free version, and the VBA code is
available for purchase, which allows you to customize the form.

http://j-walk.com/ss/dataform/index.htm

Perhaps you could customize it to open at the top left of the worksheet.
 
Back
Top