View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Herman[_4_] Herman[_4_] is offline
external usenet poster
 
Posts: 5
Default Code in Sub OKButton_Click to trigger actions depending on calling macro

Hello,
I'm looking for appropriate code in de OKButton of a multi item
listbox.
This code should trigger different actions depending on which
procedure the UserForm was called from.
I mean if the UserForm is called by macro A the action should be aaaa
and if it is called by macro B the action should be bbbb etc.

How can I refer to the calling macro in the OK Button code ?
Thanks a lot
Herman