Scrolling Ebbeded SubForm - Up for a challenge?

[Craig9999]

Hello all you Excel masterminds.

Stumping problem giving me a headache, and they say a problem shared is a problem halfed so here it is.

I have a form in excel. Into this form I would like to place either a subform or frame (or what ever). The subform is about an A4 page long, and the space on my orginal form is about 3 inches high, so I need to be able to scroll up and down the subform until all the entries are complete.

Question does Excel do SubForms?

Please help grovel grovel.


Craig

 

[ssVBAdev]

Well, I'm not sure what you are going after in terms of a "sub-frame" but if you could put your object into a frame you could do something like this (copy this code to a form with a "Frame1" and a "Scrollbar1" then play around with it to get what you want):


Option Explicit

Private Sub ScrollBar1_Change()
Frame1.Top = -ScrollBar1.Value
End Sub

Private Sub UserForm_Activate()
With ScrollBar1
.Max = 150
.Min = 1
.LargeChange = 25
.SmallChange = 1
End With
Frame1.Top = 1
End Sub



********************
What's the best way to get the answers you need?? See FAQ222-2244 for details!

 

[Craig9999]

Great Thanks a million.

Have a great day

Craig :-D