Results 1 to 3 of 3

Thread: [RESOLVED] Help with passing argument to function

  1. #1

    Thread Starter
    Hyperactive Member AccessShell's Avatar
    Join Date
    Oct 2013
    Posts
    318

    Resolved [RESOLVED] Help with passing argument to function

    I have a function that needs to be run for three different array of controls. Can I pass the control name to the function for each array? If so how?

    Thanks

  2. #2
    PowerPoster
    Join Date
    Feb 2017
    Posts
    2,704

    Re: Help with passing argument to function

    Yes, use Variant.
    Variant types can hold almost anything.

    Code:
    Private Function MyFunction(nControlArray As Variant)

  3. #3

    Thread Starter
    Hyperactive Member AccessShell's Avatar
    Join Date
    Oct 2013
    Posts
    318

    Re: Help with passing argument to function

    Thanks Eduardo. It works great. Just what I needed.

Posting Permissions

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



Click Here to Expand Forum to Full Width