View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DBAL[_4_] DBAL[_4_] is offline
external usenet poster
 
Posts: 6
Default 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