Posted to microsoft.public.excel.programming

Greg Glynn[_4_] Greg Glynn[_4_] is offline

external usenet poster

Posts: 6

Scrollbar not talking to me.

I have a worksheet with 5 scrollbars on it. The following code doesn't
work. It gives me:
runtime error 424: Object required (When trying to reset the value of
scrollbar 1).

Windows("Surveys.xls").Activate
Range("Comments").Value = ""

'This next bit should work - But didn't.
ScrollBar1.Value = 0
ScrollBar2.Value = 0
ScrollBar3.Value = 0
ScrollBar4.Value = 0
ScrollBar5.Value = 0

Anyone know why?

Thanks in advance

Greg

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Talking about difficult thingsÂ¡Â¡Â¡Â¡	filo666	Excel Programming	3	April 30th 05 01:48 AM
scrollbar reslut makes another scrollbar to show	Patrik	Excel Discussion (Misc queries)	0	April 18th 05 03:11 PM
Excel and Access talking	GJR3599	Excel Discussion (Misc queries)	0	March 29th 05 04:59 PM
Talking to a class or type between 2 sheets	Torben Laursen	Excel Programming	1	September 16th 04 12:30 PM
Talking to a Perl script	hgrove[_6_]	Excel Programming	0	July 20th 04 01:19 AM

All times are GMT +1. The time now is 01:51 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us