elPit
03-18-2003, 09:57 AM
Hello, I'm doing a Visual Basic Project using interaction with Excel. I found a problem when i try to write or read a "TextBox" on an Excel sheet, as simple as i don't know how (even read a book).
By now i have this:
----------------
Dim Control As Worksheet
Dim Status As OLEObject
Set Control = Logiciel.Worksheets("Control")
For Each Status In Control.OLEObjects
If Status.Name = "StatusTextBox" Then GoTo Trouve
Next Status
Trouve:
'code needed for write and read my textbox called StatusTextBox
------------------
How can i do?
Another question is how can i display a window (can be a VB form) with out stop running my code.
By now i have this:
----------------
Dim Control As Worksheet
Dim Status As OLEObject
Set Control = Logiciel.Worksheets("Control")
For Each Status In Control.OLEObjects
If Status.Name = "StatusTextBox" Then GoTo Trouve
Next Status
Trouve:
'code needed for write and read my textbox called StatusTextBox
------------------
How can i do?
Another question is how can i display a window (can be a VB form) with out stop running my code.