How do I make a user form scrollable at runtime 2

[SBendBuckeye]

I have done much more VBA than VB so please bear with me if the answer to this question is obvious. I have a user form that is data driven. At load time I am creating a control array, basically one line per data item.

For purposes of our discussion, lets say the form fills the screen at 10 lines. So, at 10 lines or less I am fine. When there are more than 10, I need to set the form up to scroll vertically. How do I do that?

Thanks for any help and/or suggestions!

Have a great day!

j2consulting@yahoo.com

 

[zemp]

Use MDI forms. Create a parent MDI form to hold your menus and toolbar (if used) and a child form to hold the data. The child form can have a vertical scroll bar if necessary and you can scroll it.

Take Care,

zemp

"Show me someone with both feet on the ground and I will show you someone who can't put their pants on."

 

[SBendBuckeye]

Can you use MDI forms inside a PropertyPage as I am using the form within Outlook as part of an Add-In?

Thanks!

Have a great day!

j2consulting@yahoo.com

 

[zemp]

That I am not sure about. Never tried using them that way.

Take Care,

zemp

"Show me someone with both feet on the ground and I will show you someone who can't put their pants on."

 

[nicsin]

Hi SBendBuckeye,

take a look

http://www.vb-helper.com/howto_show_hide_text_scrollbar.html

You might have to do some adjustments to suit your situation.

Regards,
nicsin

 

[SBendBuckeye]

Zemp, the MDIForm is grayed out in the Projects menu for property pages, so I guess the answer is no.

Nicsin, thanks for the link, I have not been able to try it but I really appreciate the help.

Have a great day!

Have a great day!

j2consulting@yahoo.com

 

[VBDemiGod]

steve mcmahons vbaccelerator.com site has a class that can add 'real' win32 scrollbars to any object with an hwnd. Simple!