T
Terry
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
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