+ Reply to Thread
Results 1 to 6 of 6

VBA Related Question_Newbie

  1. #1
    Registered User
    Join Date
    01-21-2018
    Location
    Singapore
    MS-Off Ver
    2010
    Posts
    5

    VBA Related Question_Newbie

    Hi All,

    Im still learning to do vba programming. Can i write multiple codes in the same module?

    Because recently i was trying to do some coding and let say:

    Sub Code 1 - just an additional (2 +2 ) function
    Sub Code 2 - just to select a cell

    Then i assign a button to Sub code 2.

    But when i run it, doesn't work.

    However, when i tried copying Sub code 2 in different module, it worked.

    Does it mean i cant use 2 Sub codes in 1 module?

  2. #2
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: VBA Related Question_Newbie

    Just a select a cell, you may miss to notice - whether it got selected it not.
    Nevertheless, you can add as many sub as in a module in excel vba.
    Regards,
    Thangavel D

    Appreciate the help? CLICK *

  3. #3
    Valued Forum Contributor
    Join Date
    03-16-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    371

    Re: VBA Related Question_Newbie

    You can, they just need unique names. It should look something like this:

    Please Login or Register  to view this content.
    Design everything to be as simple as possible, but no simpler.

  4. #4
    Registered User
    Join Date
    01-21-2018
    Location
    Singapore
    MS-Off Ver
    2010
    Posts
    5

    Re: VBA Related Question_Newbie

    Thank you All. Really appreciate your answers.

    Long way to go to learn this programming..

  5. #5
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: VBA Related Question_Newbie

    Appreciation can also be done by adding rep to the useful post...

  6. #6
    Valued Forum Contributor
    Join Date
    03-16-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    371

    Re: VBA Related Question_Newbie

    Everybody has to start at the beginning! Keep asking and you'll keep learning
    If that takes care of your original question, please select Thread Tools from the menu link above to mark this thread as SOLVED.
    To say thanks to the user(s) who contributed towards the solution, you can use the "Add Reputation" button on their helpful post(s).
    Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. I want to extend related tables that have related formulas
    By earlyyyyyy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-10-2015, 10:08 AM
  2. IF related
    By Nirmal in forum Excel General
    Replies: 1
    Last Post: 12-12-2011, 07:52 PM
  3. XML related problem
    By mameha1977 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-10-2009, 02:27 AM
  4. [SOLVED] Tabstrip related
    By tkraju via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-04-2006, 09:15 PM
  5. [SOLVED] macro related
    By Ankur in forum Excel General
    Replies: 3
    Last Post: 08-17-2005, 07:05 AM
  6. [SOLVED] module related
    By Monique in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-13-2005, 12:05 PM
  7. I have a VB related question,...
    By javabeens in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-07-2005, 01:05 PM

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