![]() |
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, |
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, |
All times are GMT +1. The time now is 06:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com