ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   MS Dialog 5.0 sheets - Accessing data elements of objects (https://www.excelbanter.com/excel-worksheet-functions/29218-ms-dialog-5-0-sheets-accessing-data-elements-objects.html)

Malriem

MS Dialog 5.0 sheets - Accessing data elements of objects
 
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,

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

"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,


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


"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,





All times are GMT +1. The time now is 06:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com