Scroll Bars in a form

**dextras** · 07-03-2009, 02:02 AM

What I need to do is add a scroll bar to my text box in my form. I used the properties of the text box to add a scroll bar but when you preview it you can't see it. When you click somewhere inside the form it appears and is workable but not when it hasn't been clicked on. How do I make the scroll bar appear from the start. this is a vertical one ad is on a text box within the form

**royUK** · 07-03-2009, 02:22 AM

The TextBox MultiLine Property needs setting to True. The scrokkbar will become visible as data is entered

**dextras** · 07-03-2009, 02:27 AM

Already done. The textbox already has data in it. I am not using it as a thing to be able to have data entered into it. I guess I should be using something else. Label? If so how would then deal with the scroll vars

**royUK** · 07-03-2009, 07:14 AM

What data are you putting in? maybe you could use a listbox

**Andy Pope** · 07-03-2009, 07:30 AM

This works for me.
Userform textbox and command button

Please Login or Register  to view this content.

If the textbox is first in the Tab order the activation event code in not required.

The scrollbars are only displayed if the text is long enough.

**dextras** · 07-04-2009, 01:26 AM

Here's my spreadsheet. How would I add in the code? I'm not sure where you'd add it. It's for the "help" userform.

**royUK** · 07-04-2009, 03:30 AM

Just add this to your userform

Please Login or Register  to view this content.

**dextras** · 07-04-2009, 03:53 AM

That works except it focuses to the bottom of the scroll box. This means that then you are scolled to the bottom when you open it. How can i fix this?

**Andy Pope** · 07-04-2009, 05:41 AM

All you actually need in your userform, to fix the problem, is the following.

Please Login or Register  to view this content.

**dextras** · 07-04-2009, 06:10 AM

Thank you, that's exactly what i needed. I would have thought that you wouldn't need to do all that other stuff to get it done
+1

**royUK** · 07-04-2009, 06:15 AM

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

**dextras** · 07-04-2009, 06:30 AM

^ I didn't solve it myself. You gave me stuff which woked but not completely but then Andy Pope gave me this:

Originally Posted by Andy Pope

All you actually need in your userform, to fix the problem, is the following.

Please Login or Register  to view this content.

which is above

EDIT: I already put it as solved. I'm confused lol

Scroll Bars in a form

LinkBack

Thread Tools

Rate This Thread

Display

Scroll Bars in a form

Re: Scroll Bars in a form

Re: Scroll Bars in a form

Re: Scroll Bars in a form

Re: Scroll Bars in a form

Re: Scroll Bars in a form

Re: Scroll Bars in a form

Re: Scroll Bars in a form

Re: Scroll Bars in a form

Re: Scroll Bars in a form

Re: Scroll Bars in a form

Re: Scroll Bars in a form

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions