Accessing object on different sheet

[Mr930]

I built some VBA code where I do some stuff to a list box. I have moved the list box to a different sheet and now the code says it cannot find it. How do I reference the List Box now that it is on a different sheet?

thanks
Fred Emmerich

 

[doofusboy]

Just put the sheet name in front of the textbox name. Something like:

Sheet2.YourTextBoxName.Text = "Voila"

 

[Mr930]

Well that was too easy! thanks

 

[Mr930]

Did not work, says "object required"

 

[VoG]

Try like this

Sub test()
Sheets("Sheet1").TextBoxes("TextBox 1").Text = "Fred"
End Sub

 

[Mr930]

I am triggering my code off a button on the sheet that does not contain the list box. I change to the sheet that does have the list box by using Worksheets(...).Select, but this does not seem to help. WOuld it be a public/private issue on the list box?

 

[VoG]

I just tried this on Sheet2 and it worked

Private Sub CommandButton1_Click()
Sheets("Sheet1").TextBoxes("TextBox 1").Text = "Fred"
End Sub

Where is the textbox from - the Forms toolbar or the Controls toolbar?

 

[Mr930]

ActiveX toolbar...

I got this to work:

Worksheets("Sheet1").OLEObjects("ListBox1").ListFillRange = "MyRange"