VBA userform in excel

[Streng]

Have completed a code within AutoCAD VBA to export all required info to an excel spreadsheet.

My next problem is updating the code within excel, I am wanting to do this with simple userforms.

As all my code is in CAD VBA, is there a way I can show the userforms in excel - not in CAD.

Alternatively can I produce a new excel code and load that at the end of the CAD code

Hope i've explained it ok

[kerbocad]

I don't know anyway to get your CAD VBA forms to show up in Excel. However you can call Excel Macro's from an AutoCAD Macro.

Example:

Dim XLApp As Excel.Application
Set XLApp = GetObject(, "Excel.Application")
XLApp.Application.Run "Book1!Macro1"

[Ed Jobe]

It depends on what you want to do with the form in xl. However, you can design a form in xl and call it from acad. A form designed in acad can define and reference xl objects as well.

[MikeJarosz]

Just a thought.... I haven't tried this myself but.........

Tile the Acad and Excel windows on your screen so that popup windows in both will be visible.