VBA to copy dialog sheet text box contents

Posted by Daniel C on December 02, 2001 10:36 AM

Hi to all excel wizards out there.
I really need a single line of code that will let me
take the text i type into a named text box (studentname)
on a running dialog form that
i manually build in Excel (not a VBa userform). I need
to be able to say take the text inside the box and not
the box itself so that it can then be pasted into
a new line's offsetted cell.

Thanks in advance to anybody who can help me

Daniel C

Posted by Bariloche on December 02, 2001 2:46 PM

Daniel,

The following (with appropriate modifications for your code) should be the syntax you're looking for:

Range("A1") = ThisWorkbook.DialogSheets("MyDialog").EditBoxes("EditBox1").Text

Hope this helps