Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How can I pass Excel events to a designer form in an ActiveX DLL ?
I had created a userform in Excel VBA that contains Excel's refedit controls to easily select cell references from Excel worksheets. It works fine when it was executed in Excel's VBA. This userform was then added to an ActiveX DLL and became a Designer form. My VB6 application creates the object for this class defined in the ActiveX DLL above in Excel. From Excel, a worksheet event would activate the loading of the object's userform. However, when this object's Designer form show event is executed, it does not stop to allow the user to enter and complete its fields. I had tried the Windows API function to set it back to the foreground but the form seems to ignore any of the Excel Events. I can't set it to modal mode either. Can anyone tell me what's seems to be wrong ? Thanking you in advance for any advice or help you can offer. Rdgs, Terry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Controlbox - Form Control - ActiveX | Excel Discussion (Misc queries) | |||
How do I switch form annual events list to my orginal calender | Excel Worksheet Functions | |||
A form to keep track of monetary goals for dated events and offeri | Excel Discussion (Misc queries) | |||
How do I setup a cell in Excel as a checkbox w/o a form/activex c. | Excel Discussion (Misc queries) | |||
Dynamic TextBox ActiveX events | Excel Programming |