If Statement in Function code, what is missing?

**ChicPea** · 06-21-2009, 08:01 PM

Hi,

I am new to VBA an trying to write a function that the result wil be a two letter string that shows what type of hours have been worked on an Overtime form. The choices are OT for Overtime, AD for Additional hours or CO for Callout hours.

I have written the below script but no result is produced am I am at a loss to work out what I have missed. Can anyone please help?

Please Login or Register  to view this content.

**JBeaucaire** · 06-21-2009, 08:09 PM

Without spending any time analyzing, I can't imagine the typo on the first line isn't hurting somehow:

Please Login or Register  to view this content.

**shg** · 06-21-2009, 10:24 PM

ChicPea,

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

**ChicPea** · 06-22-2009, 01:19 AM

Hi JBeauCaire,

Thanks f0r pointing out the typo but it is correct in the file that I am working on. This typo is just me doing things in a hurry. If you could have a look at the code, it would be appreciated.

Thanks.

**JBeaucaire** · 06-22-2009, 03:18 AM

Let's have a sample workbook with that function be implemented. Easiest to test on your actual data.

Then click GO ADVANCED and use the paperclip icon to post up your workbook.

**royUK** · 06-22-2009, 03:33 AM

This is a duplicate post

http://www.excelforum.com/excel-prog...n-problem.html

ChicPea read the Forum Rules and follow them. If you continue posting like this ans so wasting members' time you will find your posting rights removed!

I corrected your code yesterday and you haven't even bothered with that post