Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Scrolling in Multipages

Guys,

I have created a userform where I have put a multipage in
it. In each page of this multipage I'm putting alot of
things which causes me to enable the vertical scrolling
obtion on in the property of each page. However, I could
not get it working. For some reason this option is not
working. although it shows the scroll bar at the right
of the form it does not work; i.e.; it does not show the
rest of the buttons and text boxes at the bottom of the
form.

Can any body help me with this.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 218
Default Scrolling in Multipages

You seem to be getting ingnored. What did you set the
Scrollheight property to?

The following code will is proven to work in xl2000. You
need only to run the macro. You may have to correct for
wordwrap and for the doubling of periods within With/End
With statements. Test it and see if it works. If not
we'll need more info.

Sub TestScrollbars()
Dim i As Integer, ii As Integer
Dim UF As Object, TB As Control
Dim Multi As MultiPage
Set UF = Application.VBE. _
ActiveVBProject.VBComponents.Add(3)
UF.Properties("Height") = 200
UF.Properties("Width") = 130
Set Multi = UF.Designer.Controls.Add("Forms.MultiPage.1")
With Multi
..Height = 160
..Width = 115
..Top = 5
..Left = 5
End With
For i = 0 To 1
Multi.Pages(i).ScrollBars = 2
Multi.Pages(i).ScrollHeight = 350
For ii = 1 To 20
Set TB = Multi.Pages(i).Controls.Add("Forms.TextBox.1")
With TB
..Font.Size = 8
..Left = 10
..Top = ii * 15 + 5
..Height = 15
..Width = 40
..Text = "Test"
End With
Next ii
Next i
VBA.UserForms.Add(UF.Name).Show
ThisWorkbook.VBProject.VBComponents.Remove UF
End Sub

Regards,
Greg

-----Original Message-----
Guys,

I have created a userform where I have put a multipage in
it. In each page of this multipage I'm putting alot of
things which causes me to enable the vertical scrolling
obtion on in the property of each page. However, I could
not get it working. For some reason this option is not
working. although it shows the scroll bar at the right
of the form it does not work; i.e.; it does not show the
rest of the buttons and text boxes at the bottom of the
form.

Can any body help me with this.
.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel- smooth scrolling (instead of 'snap' scrolling) scooterbaga Setting up and Configuration of Excel 2 April 24th 08 02:16 PM
Scrolling alexc Excel Discussion (Misc queries) 2 April 23rd 07 09:13 PM
Vertical scrolling...jumps rather than smooth scrolling Miller Man Excel Discussion (Misc queries) 2 January 23rd 07 07:11 PM
Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel, even 2007 beta [email protected] Excel Discussion (Misc queries) 2 July 21st 06 01:21 AM
Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel 2003 [email protected] Excel Discussion (Misc queries) 0 May 12th 06 03:15 AM


All times are GMT +1. The time now is 11:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"