LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Handling Excel Events in a Designer form in an ActiveX DLL

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Controlbox - Form Control - ActiveX CousinExcel Excel Discussion (Misc queries) 1 March 20th 10 12:16 PM
How do I switch form annual events list to my orginal calender Kirk Polson Excel Worksheet Functions 1 August 7th 08 02:05 PM
A form to keep track of monetary goals for dated events and offeri J&W Excel Discussion (Misc queries) 0 October 8th 07 07:25 PM
How do I setup a cell in Excel as a checkbox w/o a form/activex c. Arno Rite Excel Discussion (Misc queries) 15 November 27th 06 08:50 PM
Dynamic TextBox ActiveX events Tom Ogilvy Excel Programming 0 September 29th 03 08:56 PM


All times are GMT +1. The time now is 10:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"