ScroolBar - Showing Blank Names

[Terry]

Hi Guys

In Excel 2002 I have a scrollbar that works whwn I scroll up & down ie
records change on the form but the scrollbar is empty I dont see anything in
the scrollbar

What am I doing wrong? - Terry

 

[Gord Dibben]

How did you create this scrollbar?

Is it a listbox or combobox from the Forms or Control Toolbox?

If you scroll up and down and records change on the form there must be
something driving the changes.


Gord Dibben MS Excel MVP

 

[Terry]

Thanks for the reply Gord

It's a scrollbar on a form in VBA below is the code

I tried Me.ScrollBar1.RowSource = "a4:a11" but gives an error any way i
code it

Private Sub UserForm_Initialize()
Set DataSheet = ActiveSheet
RecNum = 3
Me.ScrollBar1.Min = 3
Me.ScrollBar1.Max = DataSheet.Cells(DataSheet.Rows.Count, 1).End(xlUp).Row + 1
Me.ScrollBar1.Value = RecNum
Me.CommandButton1.Caption = "Save"
Me.Label1.Caption = "Name"
End Sub