Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel control toolbox

Status
Not open for further replies.

GLENEE

Programmer
Feb 9, 2005
64
GB
I have a textbox on worksheet(1) called txt1.
Is there anything wrong with the following as i can't get it work:

strC = "txt1"
debug.print worksheets(1)(strC)
or
debug.print worksheets(1).strC


the error produced is 438 'object does not support this property or method..'
Thanks
 



Hi,

Please post VBA code questions in Forum707.

Skip,

[glasses] To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white] [tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top