PDA

View Full Version : Can Forms Be Truly Docked?



ronjon65
11-15-2011, 09:27 AM
I want to create a form that is docked to a certain position with respect to the window (in this case right at the corner of "A1"). A few problems:

- I cannot find a good way to start the position right at "A1" (but showing A and 1).
- Can the form move with the window? Otherwise, it becomes a disconnected "mess".

This seems to be tricky and may not even be possible?

mdmackillop
11-15-2011, 12:59 PM
Thankfully, Mr Pearson has looked at this issue here (http://www.cpearson.com/excel/formposition.htm)

ronjon65
11-15-2011, 02:40 PM
Well that is pretty nifty, but it doesn't look like it the Form will move with the window. It will get it positioned initially, but that is probably not good enough for many users.