Scroll Bar in Excel 2002

[Carla Bradley]

I have a client that has excel 2002. She has added a
scroll bar to a cell in a very simple spreadsheet. There
is lots of data in that one cell that she wants to be
able to scroll through. She added the scrollbar using the
control toolbox, but after exiting design mode the scroll
bar does not work. Neither of us know visual basic, but
here is the code that it generated automatically. Is
there something else that needs to be done to have this
scroll bar work?

Private Sub ScrollBar1_Change()

End Sub

Thanks!!
Carla

 

[ross]

Carla

As far as i am aware, you can't add a scroll bar to a cell, what you
have done is put a S/B on to the "picture" layer of the worksheet
(there is an invisiable sheet for picture and controls to go on), i
dont have 2002 with me at the mo, so i'm not 100% but i dont think you
can add a SB to a CELL,... also why?
any way sorry not much help
ross
ps the code
Private Sub ScrollBar1_Change()

End Sub
is the deflut code of the control

 

[ross]

Carla

As far as i am aware, you can't add a scroll bar to a cell, what you
have done is put a S/B on to the "picture" layer of the worksheet
(there is an invisiable sheet for picture and controls to go on), i
dont have 2002 with me at the mo, so i'm not 100% but i dont think you
can add a SB to a CELL,... also why?
any way sorry not much help
ross
ps the code
Private Sub ScrollBar1_Change()

End Sub
is the deflut code of the control