Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ShowDataForm | Excel Discussion (Misc queries) | |||
STILL CAN'T LOCATE XML | New Users to Excel | |||
print box opens in right screen of dual screen setup why | Excel Discussion (Misc queries) | |||
Need to convert point on screen to various screen resolutions | Excel Discussion (Misc queries) | |||
ShowDataForm method | Excel Discussion (Misc queries) |