excel - vba - userform - frame - set scrollbar position

excel scrollbar excel-2010 userform vba
ramtoo picture ramtoo · Mar 4, 2013 · Viewed 11.2k times · Source

How do I set the scrollbar position of a frame(inside an userform)?

The case:

I have a frame in an userform that has dynamic content. So if the content is too big to fit the frame, it (dynamically) creates a scrollbar in that frame. The scrollbar also has dynamic values, following the frame content size.

The code that updates the scrollbar is as follows:

With userform1.frame1
    'dynamic size
    .ScrollHeight = param1 * param2
    .ScrollWidth = .InsideWidth * 30
End with

So I'd like to have something to send the scrollbar to the bottom position! How do I do that? Thanks in advance

Answer

barrowc picture barrowc · Mar 4, 2013

After setting the ScrollHeight and ScrollWidth and still inside the With block try:

.Scroll ActionX:=fmScrollActionNoChange, ActionY:=fmScrollActionEnd

More details can be found here

Related questions

Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More
IF statement: how to leave cell blank if condition is false ("" does not work)

I would like to write an IF statement, where the cell is left blank if the condition is FALSE. Note that, if the following formula is entered in C1 (for which the condition is false) for example: =IF(A1=1,B1,"") …

Read More
'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

I'm trying to get data from an Excel file on a button click event. My connection string is: string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\source\\SiteCore65\\Individual-Data.xls;Extended Properties=Excel 8.0;"; When I click on the button, …

Read More