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,

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...)

"Malriem" wrote:

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,

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


"Malriem" skrev i melding
...
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,