Multiple Frames on a userform

[Guest]

I have a form that is created on initialization. The width of the userform
is 750 and the width of the frame is 1200. Frames are placed neatly down the
form with no overlapping. Each frame has 20 controls inside. My problem is
when you click from one fram to the next, the form seems to "jump" and the
control that the user tries to select has been moved to the right most
position on the viewable portion of the form. how can I keep the userform or
screen from jumping when moving from on frame to the next?

thx

 

[keepITcool]

James
750 wide for a form and 1200 wide for a frame....
wrong design? imo users shouldnt need hscroll on a userform.


if the frame contains enabled controls in the area of the frame that's
not visible the user can still tab to them... (and wondering where the
hell his focus is

experiment with the scrollwidth of the form: set to 1200 or a bit more.
or ensure that controls in the outback are disabled.
(or encapsulated in another frame(which is disabled)

I this still the exercise to get 1500 controls on the form?
i seem to remember that.. also that everybody concurred you needed
a redesign. i cant see any need for that many controls,
except as a deliberate effort to make things overcomplicated..

Any user would be overwhelmed... and what do you need those controls
for anyway?

else mail me your workbook. and I may be able to advice
on the redesign. use rot13 on sender or add @ and . to email below.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


James McDowell wrote :

 

[Guest]

Sorry, you must have me confused with another posting. I am not adding 1500
controls. Adding about 20 frames with 20 controls in side each.
The problem is the jumping effect when moving from one frame to the next.
My scoll width for the userform is set to 1250 where the frames are only
width of 1225. If the user has the form visable and is say on the 15th
control out to the right, and they click on the matching control below it, in
the next fame. The entire frame moves so the clicked control is in the
right-most position of the screen. When before it could have been in the
middle or the left of the viewable screen.

thx

 

[keepITcool]

James,

if you cant get it solved please mail me the workbook
and I'll have a look at it.. after I get some sleep
(it's been a long night)

email below (add @ and .) or rot13 on sender address

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


James McDowell wrote :