Results 1 to 2 of 2

Thread: How do I move code from sheets to modules?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Aug 2018
    Location
    NSW, Australia
    Posts
    705
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default How do I move code from sheets to modules?

    At the moment, all my code is stored in two sheets and I want organise my code a little better by moving some of it into modules. I don't know how to move it to modules and have it still work, for instance, have the command button still run the code when it is clicked. How do I do this?

  2. #2
    Board Regular Norie's Avatar
    Join Date
    Apr 2004
    Location
    Stirling, Scotland
    Posts
    75,045
    Post Thanks / Like
    Mentioned
    60 Post(s)
    Tagged
    6 Thread(s)

    Default Re: How do I move code from sheets to modules?

    What type of button(s) are you using?

    Is any of the code in the sheet modules for events e.g. Change?
    If posting code please use code tags.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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