MS Dialog 5.0 sheets - Accessing data elements of objects

M

Malriem

Pretty much what i want to do is access data that is typed into a textbox on
a dialog. Now I am not talking about using the controls off of the "Control
Toolbox" menu. I am talking about a dialogsheet. Any ideas? I could do
something like capture each keyboard stroke but that just sounds like alot of
work... must be a property for those little devils,
 
M

Malriem

Probably should clarify - doing this in MS Excel XP though VBA. Want to save
the textbox data to a string and port all to a formatted word document.
(already figured out the rest, just cant grab the data from the textboxes...)
 
H

Harald Staff

That is an EditBox, not a textbox. So

Sub test()
Dim S As String
S = DialogSheets(1).EditBoxes(1).Text
MsgBox S
End Sub

HTH. Best wishes Harald
 
Top