Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,814
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ShowDataForm Steve Excel Discussion (Misc queries) 0 August 15th 07 09:48 PM
STILL CAN'T LOCATE XML emi New Users to Excel 1 July 24th 07 11:04 PM
print box opens in right screen of dual screen setup why gerrys Excel Discussion (Misc queries) 1 June 30th 06 06:47 PM
Need to convert point on screen to various screen resolutions Donna YaWanna Excel Discussion (Misc queries) 5 October 26th 05 10:10 PM
ShowDataForm method nc Excel Discussion (Misc queries) 4 March 8th 05 10:09 AM


All times are GMT +1. The time now is 02:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"