Excel worksheet in userform

[grobnik]

Hi to everybody,

Just a question: how integrate an Excel sheet inside an userform made with Autocad VBA ? is there any additional control to insert in the userform ?

Of course I need to manage data in a different way than a listbox or combobox.

Thank you for any suggestion.

Bye

[norman.yuan · Accepted solution]

It is not possible to directly place Excel sheet in AUtoCAD VBA's UserForm. In old days, with classical VB5/6, it was possible to place an OLE object in a VB form/UserControl. Then you would be able compile the VB5/6 as COM control and used in AutoCAD VBA. But that was 32-bit era and it has long passed its life.

Also Speadsheet and AutoCAD work in very different functionalities. If the purpose of integrating it in AutoCAD is mainly for presentation, you there are quite other options, especially if you do AutoCAD .NET API, where you have may choices of third party UI controls of gridview types, or do it yourself (for example with WPF). Unfortunately, because of lack of UI support it is not practical to pursue it with 64-bit VBA.

[grobnik]

@norman.yuan 

Hi Norman, thank you for your answer.