<div>
set the default &quot;value&quot; property of the scroll bar to 0
</div>


set the default "value" property of the scroll bar to 0

<div>
Ok, how do you do that in the code ?<br />
<br />
With Me<br />
<br />
ScrollBars = fmScrollBarsBoth<br />
&nbsp; &nbsp; &nbsp; &nbsp; .ScrollHeight = .InsideHeight * 1.2<br />
&nbsp; &nbsp; &nbsp; &nbsp; .ScrollWidth = .InsideWidth * 1.2<br />
&nbsp; &nbsp; &nbsp; &nbsp; .ScrollLeft = 3<br />
&nbsp; &nbsp; &nbsp; &nbsp; .ScrollTop = 2<br />
&nbsp; &nbsp; <br />
End With
</div>


Ok, how do you do that in the code ?

With Me

ScrollBars = fmScrollBarsBoth
        .ScrollHeight = .InsideHeight * 1.2
        .ScrollWidth = .InsideWidth * 1.2
        .ScrollLeft = 3
        .ScrollTop = 2
   
End With

<div>
sorry, I thought you were refering to a scrollbar control that you had added to the form, not the scroll bar of the form itself.<br />
<br />
Does it work like you want if you cange the left and top properties to 0? &nbsp;Maybe Im confused with what you are asking.<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; .ScrollLeft = 0<br />
&nbsp; &nbsp; &nbsp; &nbsp; .ScrollTop = 0
</div>


sorry, I thought you were refering to a scrollbar control that you had added to the form, not the scroll bar of the form itself.

Does it work like you want if you cange the left and top properties to 0?  Maybe Im confused with what you are asking.

        .ScrollLeft = 0
        .ScrollTop = 0

<div>
No it doesnt work. <br />
Ok so this is what happens. <br />
WHen i open the userform. The scrollbar is scrolled to bottom. so It does not start from the top of the userform (bottom part is visible at first), because it is scrolled down to bottom. 
</div>


No it doesnt work.
Ok so this is what happens.
WHen i open the userform. The scrollbar is scrolled to bottom. so It does not start from the top of the userform (bottom part is visible at first), because it is scrolled down to bottom.

<div>
Which control on your form is first in the tab order? Is it one at the bottom?
</div>


Which control on your form is first in the tab order? Is it one at the bottom?

<div>
<div class="content wysiwyg-content">
When I open my userform , the horizontal scollbar starts form the middle of the page instead of the top. How can solve this problem?<br />
thanks,
</div>
</div>


When I open my userform , the horizontal scollbar starts form the middle of the page instead of the top. How can solve this problem?
thanks,

Scrollbar Position on VBA Excel Userform

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.