Scrollbar not talking to me.

  • Thread starter Thread starter Greg Glynn
  • Start date Start date
G

Greg Glynn

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
 
If your code you are running is not in the worksheet where the controls
reside, then declare their reference prefixed with the sheet as follows

Sheets("Sheet1").ScrollBar1.Value = 0

* changed sheet name as required
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"Another ScrollBar Question" 2
Extreme newb, easy question: Simple button/scrollbar coding 1
Code works on sheet but not from code-to-sheet 2
Copy filtered data to sheet 2 1
Re : Excel event handler Worksheet_SelectionChange 1
Need urgent help 0
BeforeDoubleClick Event not working 2
Run time 9 error for some users but not everyone 10

Back
Top