I need some serious help with this problem, I am new to VBA and don't know where to start.
A palindrome is a number or a text phrase that reads the same backward as forward.
I need to create a function procedure called Palindrome that takes one input and will output a "1" if the phrase or number IS a palindrome and a "0" if it is not. The code needs to include the following:
- For... Next loop
- If…Then conditional statement
- Len(string) function: For example Len(“abcd”) would return 4
- Mid( text, start_position, number_of_characters ) function: text is the string that you wish to extract from. start_position indicates the position in the string that you will begin extracting from. The first position in the string is 1. number_of_characters indicates the number of characters that you wish to extract. For example Mid(“abcd”, 1, 2) would return ab.
Any help would be greatly appreciated! I am lost.
Thanks in advance
Bookmarks