Hi,

Thanks for the response. Can you tell me what is the purpose of "withevents"? In other words, what is the advantage of declaring a procedure with "with events"?

>If a variable is declared with withevents inside a private sub; it will not be of any use. It has to be a module level/form level variable to handle the events of the assigned object.
>If assigned in a private sub, You cannot raise object events on it.