Calling a Subroutine, Function, several if statements

**soma104** · 02-10-2010, 11:35 AM

Hi,

I have some VBA code that I'm working on, and I'm not sure how to proceed. First of all, can I enbed one if statement inside another? If I can it would solve my problem.

This is basically what I'm going for:

Please Login or Register  to view this content.

I'm not sure if that will work. I was thinking I may need a subroutine, or a function. The results of "do this" and "do that" will be required further in my code. If I do need a subroutine or a function, which one, and where does it go, in the main code, or in a module?

Help
Soma

**Domski** · 02-10-2010, 11:49 AM

Yes, embedding multiple if statements within one another as you have described is fine, you may also want to look at Select Case.

It's not a good idea to jump around within a procedure unless you really have to so as you suggest this and that could be separate procedures which you can Call:

You would just use

Please Login or Register  to view this content.

One MyProcedureName (or whatever your sub is called) has executed it will return to the point it was called from and continue unless you have told it otherwise.

Dom

**soma104** · 02-10-2010, 11:55 AM

Thanks, but where would I write the code for this MyProcedure? Is it in with the main code, or in it's own module?

Soma

**Domski** · 02-10-2010, 12:06 PM

It can be in the same module or in another one if it makes more sense, no matter really.

Something like this as an example:

Please Login or Register  to view this content.

Dom

**soma104** · 02-10-2010, 12:10 PM

Thanks Dom,

I will give it a try. You've been a great help.

Soma

**soma104** · 02-10-2010, 04:17 PM

It didn't work, I'm sure I'm doing something wrong, but not sure what. This is currently what I have

Please Login or Register  to view this content.

There's a little more to it than this. The problem is that the msgbox is coming up empty, and the color data is not being written to the worksheet.

I'm stumped.

Soma