Text from text box and list box of the macro to be put or exported to ms excel

[Anonymous]

What code can i put in a command button to export the text from textbox and listbox to ms excel? Thank you! 

[Alfred.NESWADBA]

Hi,

may I ask which part of the question is an AutoCAD VBA part?

>> text from textbox and listbox

You can use <Textbox>.Text or <Listbox>.Text to get access to the text in that control.

>> to ms excel

That depends if you have loaded libraries which writes directly into XLSX files (using XML functionality) or you have loaded Excel and connect to it via COM/ActiveX.

Please ask more specific questions and in case it has to do with Windows Forms Control and Excel in a Microsoft VBA forum where you get answers for this type of questions much faster.

- alfred -