Adding first and last digits of a four digit number in vba

I need to write a sub program that will add the first and last digits of a number. For example, for a number like 1234: I need the answer to be 5 (1+4).
Your help is highly appreciated.
Ben

I guess this is your homework? What have you tried so far?

regards

I have no clue how to even separate the digits. In our lab we just covered the basics of writing a sub program. Didn't go over how to separate digits of anything. I have no clue on how to get started. Maybe define one variable as the first number, the second as the last then just add the variables. I just don't know how to separate them.

This is Excel. Do you need a program or can you just use a formula?

If you're using a formula, look at LEFT and RIGHT to getthe digits and SUM, or just a plus sign (+) to add them together.

If you need a "sub program", you'd use the same approach. Define a variable, put 1234 in it, use LEFT to get the first digit and RIGHT to get the last digit. Add them together in another variable and do something with it ... maybe a Msgbox.

Come back if you get stuck ... or to say thanks for pointing you in the right direction ;-)

Regards

You're welcome. Thanks for the feedback. It's good to "hear" the sense of achievement.

Regards