Textbox populate

[melewie]

Hi all,

I have a textbox (active x) on a worksheet I want this to be populate by a range (Country_RNG) when the workbook opens

Private Sub Workbook_Open()
Sheets("Front Page").Select
Country_CBX.List = Range("Country_RNG").Value

End Sub

This is on the 'This worksheet' object. Im getting runtime error 424. Any help would be great.

 

[bobsan42]

Private Sub Workbook_Open()
Sheets("Front Page").Select
[B][COLOR=Red]Sheets("Front Page").[/COLOR][/B]Country_CBX.List = Range("Country_RNG").Value
End Sub

and the code should probably be on the 'ThisWorkbook' object

 

[melewie]

Private Sub Workbook_Open()
Sheets("Front Page").Select
[B][COLOR=red]Sheets("Front Page").[/COLOR][/B]Country_CBX.List = Range("Country_RNG").Value
End Sub

I am a plank!!!!!!

Thanks for that bobsan!