Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Toledo, Ohio, USA
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Module call syntax

    Post deleted by jp2558

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    The Netherlands
    Posts
    216
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Module call syntax

    If yoy click on a button, the OnClick event fires, you can not prevent that and there is no command needed.
    If you want to execute the code of your converted macro (I assume you converted it to VBA) you have to open the properties window of the command button and put the following line right to the on click event:
    =fnYourFunction()

    Note, you have to convert your macro to a function, not to a sub!

  3. #3
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Toledo, Ohio, USA
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Module call syntax

    Thanks Bart - this worked exactly as I'd hoped.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •