Locate ShowDataForm on Screen
 

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

Locate ShowDataForm on Screen
 

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.

Steve wrote:
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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html