Help with IF Statements in VBA

[midnightorion]

I am sure this is really simple for some of you, I'm still haveing a hard time grasping this.

Any way, I was trying to get rid of the formulas on the Summaries Tab, and use VBA instead so that the code can't be altered or stepped on for the ARRIVAL and DEPARTURE formulas. I can't figure out how to make an if statement work though. I need it to check a Sheets Value, and then if the Phrase matches, use a set of values from one sheet, if not, use a another Sheets Values. I put the formulas into the sample sheets so you can see what I am talking about easier.

Also I need help with another problem that may come up, which has already in one instance. But I need help with the Time Log as well, so that if I change the name of the time log, the Sorting Macro will still work? It would be great if this same function was applied to the method above as well just in case the scenario presents itself again.

Thanks.

Time Log Example.xlsm

[JBeaucaire]

By stepped on you mean people are deleting your formulas?

Best solution I'd recommend is leave the VBA out. Instead, unlock the cells you want to allow them to edit, then PROTECT the sheet. Now the formula cells can't be edited.

[midnightorion]

Yes, people have a tendancy to delete the formulas, and then others, only GOD knows why feel they need to do things their own way.
End Result Its just too easy for people to unlock excel, at least with VBA its a little more challenging and may deter people from messing with things they don't need to touch.
I also already have alot of code I managed to find and piece together to do most of what I want done, I just need help with the IF statements and making them work.

[TMS]

Except that you then need to put a process in place to force them to enable macros.

[midnightorion]

They already know to enable the macros as I already have alot of code implemented into the project to make things a little easier for them.

[TMS]

Please Login or Register  to view this content.

Not easy enough if they are determined to make changes.

[midnightorion]

Anyone able to help me with this one?