ScroolBar - Showing Blank Names
 

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

ScroolBar - Showing Blank Names
 

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

On Thu, 4 Sep 2008 11:30:00 -0700, Terry
wrote:

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

ScroolBar - Showing Blank Names
 

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


"Gord Dibben" wrote:

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

On Thu, 4 Sep 2008 11:30:00 -0700, Terry
wrote:

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