LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Form placement on spreadsheet


Hi everyone

I hope I have this in the right section

I have a transparent box linked to a macro that causes a form t
"pop-up" on the spreadsheet when the user thinks s/he is clicking th
underlying cell. I want that darned form to always pop-up to cover tha
cell and a couple neighboring cells, but so far all I can do is set th
position manually by bringing up the form's properties window an
setting the Top and Left startup positions, along with setting th
placement to manual. That sticks it about where I need it. As long a
no one shrinks the darned spreadsheet window or simply clicks and move
the idiot form around the screen. Then I look like a complete schmult
(OK, I don't know if that is a word in any dialect, but you get th
picture)

Seems to me there should be a way to anchor such a puppy to a cell, bu
I just don't have the smarts yet

Help

--
brucem
-----------------------------------------------------------------------
brucemc's Profile: http://www.excelforum.com/member.php...fo&userid=3287
View this thread: http://www.excelforum.com/showthread.php?threadid=54967

 
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
excel form. Need data extracted to spreadsheet each time a form co MikeR-Oz Excel Discussion (Misc queries) 4 April 5th 09 05:18 AM
Spreadsheet in a form Jason Zischke Excel Programming 2 March 6th 06 10:42 AM
Add a Spreadsheet to a VB Form Dan Excel Programming 2 October 5th 04 03:53 PM
MSForm 1 - Initial placement of form Tim Coddington Excel Programming 2 October 1st 04 03:05 PM
determining coordinates for screen placement of user form PatFinegan[_10_] Excel Programming 2 January 31st 04 09:03 PM


All times are GMT +1. The time now is 01:01 AM.

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"