Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 101
Default create event in class module



Public WithEvents clsCbo As MSForms.ComboBox

Private Sub clsCbo_Change()
Call sbCboFil(clsCbo, g_DB, a.fnsrJi(clsCbo), True)
End Sub
the upper source is possible

but, below source is impossible
Private Sub clsCbo_Enter()
Call sbCboFil(clsCbo, g_DB, g_qryGetBonjeom)
End Sub
i want to make the Enter event code.




*** Sent via Developersdex http://www.developersdex.com ***
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default create event in class module

You cannot just invent events that you wish to use; you can only respond to
those generated by your object.
In your object module, the combo box at the top right lists available
events.

NickHK

"x taol" wrote in message
...


Public WithEvents clsCbo As MSForms.ComboBox

Private Sub clsCbo_Change()
Call sbCboFil(clsCbo, g_DB, a.fnsrJi(clsCbo), True)
End Sub
the upper source is possible

but, below source is impossible
Private Sub clsCbo_Enter()
Call sbCboFil(clsCbo, g_DB, g_qryGetBonjeom)
End Sub
i want to make the Enter event code.




*** Sent via Developersdex http://www.developersdex.com ***



Reply
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
CLASS MODULE & SIMPLE MODULE FARAZ QURESHI Excel Discussion (Misc queries) 1 September 7th 07 09:32 AM
Create Class Module using late binding Mariano B. Excel Programming 3 March 14th 06 07:21 PM
Application Event in Class Module ExcelMonkey Excel Programming 2 February 17th 06 12:45 AM
Handling of event raised in other class module VbaNew Excel Programming 1 January 10th 05 12:42 PM
Variable from a sheet module in a class module in XL XP hglamy[_2_] Excel Programming 2 October 14th 03 05:48 PM


All times are GMT +1. The time now is 01:48 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"