Scroll bar not appearing in text box
 

Hi all,

I have set the "Scrollbars" attribute of a text box within a form to "2 -
frmScrollBarsVertical" -- the issue is that when the form is initiated, the
scroll bar doesn't appear until the user actually clicks within the text box.
I'd like it to appear as soon as the form comes up. I noticed that a text
box doesn't have the "KppeScrollBarsVisible" attribute that a form does...

One other minor question while I'm at it -- is it possible to not have the
"x" appear on a form? I have a form that shows "Processing" that
automatically closes at the end of the sub.


Also

Thanks,


--
Robert

Scroll bar not appearing in text box
 

One other minor question while I'm at it -- is it possible to not have the
"x" appear on a form? I have a form that shows "Processing" that
automatically closes at the end of the sub.

http://oaltd.co.uk/DLCount/DLCount.asp?file=FormFun.zip

This example by Stephen Bullen shows a bunch of the things you can do with a
userform.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______