+ Reply to Thread
Results 1 to 11 of 11

How does one use a VB module in an Excel sheet's code?

Hybrid View

  1. #1
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: How does one use a VB module in an Excel sheet's code?

    you're welcome

    note that like a class you can refer to a routine as a member of its container module
    call module_name.routine_name
    for instance-necessary if you have routines of the same name in different modules
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  2. #2
    Registered User
    Join Date
    02-27-2013
    Location
    USA, Earth
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: How does one use a VB module in an Excel sheet's code?

    That's useful to know as well. I could see that being especially useful in case where one might have a combined code and someone else has unknowingly used the same routine name in a different module.

    Are there any resources of particular help that you might suggest I look into if I wanted to understand VB more?

    Also thank you again for the continued help. Its much appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1