Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using an ActiveXDll with Excel 2002 when the DLL uses a VB Form and VBA uses a Userform
I have an Excel workbook in which ALL code is in a class, other than the
code necessary to instantiate the class and load a VBA Userform. I then compile the class with VB 6 and use the compiled DLL. No problem so far. But then I got greedy and attempted to try something I've not tried before. To the VB 6 class, I added a VB Form. The VB code shows the Form 3 times. If I make the Form modeless, as expected, all the user sees is the last display of the Form. If I make the Form modal, then Excel gets hung waiting for the VB Form to do its thing each time it is displayed, so using vbModal appears to not work, and I expected this. How do I work around this? Does VB have to get the handle of the VBA Userform and then make sure that the VB Form gets displayed on top of the VBA Userform? Or is there an easier way? -- http://www.standards.com/; Howard Kaikow's web site. ------------------------------------------------ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet form vs. Userform...which is better? | Excel Discussion (Misc queries) | |||
Can a form made in Excel 2002 be converted into a fillable form? | Excel Discussion (Misc queries) | |||
Outlook 2002 calendar dates exported to Excel 2002 sort incorrectl | Excel Worksheet Functions | |||
How do I setup to tab between form fields in Office Excel 2002? | Excel Discussion (Misc queries) | |||
Can you print labels using Excel 2002 in a Word 2002 mail merge? | Excel Discussion (Misc queries) |