properties of object on another sheet
Hey everyone! I'm stuck on this. I need to set a string
variable in the VBA for Sheet1 with the value stored in
the Text property of a TextBox on Sheet2. Is there a way
to reference an object from another sheet within the same
workbook?
Something like this:
Dim strServerName, strDatabaseName As String
strServerName = ??Sheets("Sheet2").??.txtServerName.Text
strDatabaseName = ?????????.txtDatabaseName.Text
Please advise.
DBAL
|