Consulting

Results 1 to 3 of 3

Thread: Basic Help

  1. #1
    VBAX Regular
    Joined
    Jun 2015
    Posts
    7
    Location

    Basic Help

    I'm new to VBA so this is super basic but I'm just not sure about this..

    I''ve written several codes and then another master code to call them all together and assigned it to a button in the first worksheet of my workbook.

    Now that I am all done editing, I'm hoping to run all the code with the click of that button but each time it opens up the Visual Basic app and I have to click run for each specific string.. Is there a way to bypass this and have it work in the background or just run all together?

    I created the code to cut down on the amount of clicking through the workbook and I don't want to defeat the purpose of the code by needing to click run again and again.

    Any help is much appreciated!

  2. #2
    VBAX Expert
    Joined
    Oct 2012
    Posts
    726
    Location
    In the code window select Debug > Clear All Breakpoints

  3. #3
    VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    Post your code for us to look at.

    The easiest method is to copy the code in VBA, then click the # icon in the VBAX editor, then press Ctrl+V.

    As long as the cursor is between the [ CODE ] Tags, you can paste it any way you like.

    You can also type the tags in yourself.

    The tags are [CodE ] [ /coDE ] without the spaces. Case doesn't matter.

    Putting the tags around your code will format it in a manner making it easier for us to read.
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

Tags for this Thread

Posting Permissions

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