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

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 :

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

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" wrote:


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 :

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

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 :

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" wrote:


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 :

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