Scroll Bars In VBA User Forms????

**richardeallen** · 07-06-2007, 09:03 AM

Hi
Can anyone tell me how to get the vertical scroll bars that I've inserted into a text box within a VBA userform to start at the top????
They work fine but when you click on the command button on my excel sheet the form appears as it should except that the scroll bar is all the way at the bottom so the upper text is cut off.
I'm sure there must be a pretty simple fix.

Cheers

**antoka05** · 07-06-2007, 09:46 AM

You may use this macro:

Please Login or Register  to view this content.

See the attached file UserForm. I hope it's what you need.

Regards,
Antonio

**richardeallen** · 07-06-2007, 10:08 AM

Thanks for your help.
I could not find a user form attached to the example that you sent me and i dont know where to paste the code that you described into.
Sorry if I sound a bit thick.

Thanks anyway.

**royUK** · 07-06-2007, 12:14 PM

Is your TextBox prepopulated ?

**richardeallen** · 07-06-2007, 12:32 PM

You really are talking to a beginer here!!!
Not sure what you mean by prepopulated.

I created a new form in VBA which has a text box in it and pasted in text from word.

Cheers

**royUK** · 07-06-2007, 01:15 PM

I sure what what you mean. You must be pasting into the Textbox with the userForm activated, so rset the Scrollbar using the TextBox_Exit event.

In the VB Editor select your UserForm then double click on the TextBox. make sure that Textbox is selected in the left hand drop down. In the right hand drop down find Exit then paste this code.

Please Login or Register  to view this content.

Scroll Bars In VBA User Forms????

LinkBack

Thread Tools

Rate This Thread

Display

Scroll Bars In VBA User Forms????

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions