Multiple If Statements in VBA

[JoseK70]

I am having a hard time making this macro work. It won't let me use the elseif statement. Any suggestions would be appreciated.

Please Login or Register  to view this content.

[BigBas]

Just a heads up, forum rules require you to put any VBA code in between code tags. For example

Please Login or Register  to view this content.

[MarvinP]

Hi JoseK70,

Your problem looks like you need a SELECT CASE statement to make it easier. If you use the "TO" range in a CASE statement, I think it will do what you want.

See http://msdn.microsoft.com/en-us/libr...(v=VS.80).aspx or
http://support.microsoft.com/kb/213630

[JoseK70]

Thanks for the help. I have one more question. Instead of making my variable LOne an Integer how do I keep it as a decimal? Because when it compares to my sheet it turns LOne into 1 instead of .8.

Thanks.

[BigBas]

Try changing the dimension of the variable:

Please Login or Register  to view this content.

[JoseK70]

Thanks for all the help this is what the final code looks like

Please Login or Register  to view this content.

[JieJenn]

I was thinking of SELECT statement too; it will make whoever is editing the code a lot easier to update.

[JieJenn]

I modified the code

Please Login or Register  to view this content.

[JieJenn]

Ignore the last post. Typed too fast.

Please Login or Register  to view this content.