GoTo or Run Code???

**jkauffman** · 04-09-2008, 04:47 PM

What I am needing is a way to jump from one section of the module to another section. It runs a validation step first then once completed I need it to run the email portion of the code. I have colored "RED" the two sections I need it to go from and to. Any help on this would be appreciated I have searched all over the forum and the net trying to find a way to make this work. This module runs when one button is pushed. Unless theres a way to assign two modules to a button in excel

Thanks
Jennifer

Please Login or Register  to view this content.

**shg** · 04-09-2008, 04:49 PM

Please edit your post to add code tags:

[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

**jkauffman** · 04-21-2008, 03:10 PM

Hello,

Was checking back to see if anyone had any ideas on this code for me.

Thanks
Jennifer

**mudraker** · 04-21-2008, 05:00 PM

To call another macro from the 1st macro is easy

Please Login or Register  to view this content.

Macro1 starts to run, calls macro2
after MAcro2 runs macro1 continues running from the next command after it called macro2

Note you do not need to use the word Call in front of the macro name

**jkauffman** · 04-23-2008, 09:43 AM

Thanks I see how that works but here is the code where I want to call the other Macro. I can call both my macros from another macro by themselves no problem. But for some reason it wont call the macro I have highlighted when I put the code in like this. Any thoughts???

Please Login or Register  to view this content.

**Rick_Stanich** · 04-23-2008, 10:06 AM

My first guess would be a requirement is not being met? In this section of your code you use the same "If" statement twice.

Please Login or Register  to view this content.

I would think that the string "If Range(requiredCells(i)).Value" is not evaluating to "vbNullString".

A second look I see that you reset your "If" satement to "If Range(requiredCells(i)).Value = userInput(prompts(i))", then the second "If" statement would not evaluate to "vbNullString" and the call statement would be ignored.

**jkauffman** · 04-23-2008, 10:36 AM

I see what your saying this is how the code was originally written, I don't write very much VB code but have an understanding of how it works. It is set to exit the sub once it's finished checking all the cells for data. But what I need it to do is call the Email Macro so the excel file is then emailed out, that is where I am having the problem. I can't get it to go from this macro once its done with its routine to the email macro

Thanks

Please Login or Register  to view this content.

**jkauffman** · 04-23-2008, 10:46 AM

Wooo hooo never mind my brain just exploded, I took out the second If statement and put in an else statement and NOW it works

Thanks for everyones help on this, sometimes it helps to have a few extra eyes and brain cells

GoTo or Run Code???

LinkBack

Thread Tools

Rate This Thread

Display

GoTo or Run Code???

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions