Hi all...

In a userform...

using a textbox (multiline + scrollbar enabled), that lives in a frame with
visible set to false.

When making the frame visible, the scrollbars on the text box are invisible
until the user clicks in the box (setting the focus I assume).

I would like the scroll bars to be visible at all times, not just when the
text box has focus, but barring that, to set the focus in code. The problem
with that has been that setting the focus causes the frame to move to the
back, behind other visible objects. It probably shouldn't do this, yet it
does, and obviously makes the problem worse.

1. Right clicking the various controls and using Bring Forward/Send bac
may help.
2. Menu View/Tab Order may help.
3. TextBox1.SetFocu

--
Message posted from http://www.ExcelForum.com

Hi Brian, thanks, I had tried all of those (and more) with no successs...
I found out that there was an odd interaction with the OWC10 chart object...
that for some reason always popped to the front, obscuring the text box...
the only solution was to make the OWC10 object invisible. So strange!

Thanks again


BrianB < wrote:



: 1. Right clicking the various controls and using Bring Forward/Send back
: may help.
: 2. Menu View/Tab Order may help.
: 3. TextBox1.SetFocus


: ---
: Message posted from http://www.ExcelForum.com/