Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need the cell to be blank instead of showing #DIV/0! | Excel Discussion (Misc queries) | |||
Showing names | Excel Discussion (Misc queries) | |||
Showing Series Names in Legend | Charts and Charting in Excel | |||
Office 2K3 Scroolbar Format Control missing a tab. | Excel Discussion (Misc queries) | |||
Not showing blank and non blank items in filter mode for values | Excel Worksheet Functions |