ScroolBar - Showing Blank Names

  • Thread starter Thread starter Terry
  • Start date Start date
T

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
 
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
 
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
 
Back
Top