natygrosso
New Member
- Joined
- Mar 11, 2010
- Messages
- 3
Hi,
I have an excel file like this with all the alphabet letters:
<table style="border-collapse: collapse; width: 173pt;" border="0" cellpadding="0" cellspacing="0" width="230"><col style="width: 85pt;" width="113"> <col style="width: 88pt;" width="117"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 85pt;" height="17" width="113">Original character</td> <td style="width: 88pt;" width="117">Changed character</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt;" height="17">a</td> <td class="xl63">e</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt;" height="17">b</td> <td class="xl63">v</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt;" height="17">c</td> <td class="xl63">d</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt;" height="17">d</td> <td class="xl63">I</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt;" height="17">e</td> <td class="xl63">z</td> </tr> </tbody></table>
I need two write two subs, Scramble and Unscramble. In each, ask the user for a message in an input box. In the Scramble sub, this will be an original message; in the Unscramble sub, it will be a scramble message. Then in the Scramble sub, scramble the message and display it. In the unscramble sub, unscramble the message and display it.
I would appreciate any help or can anyone point me in the right direction.
Thank you
I have an excel file like this with all the alphabet letters:
<table style="border-collapse: collapse; width: 173pt;" border="0" cellpadding="0" cellspacing="0" width="230"><col style="width: 85pt;" width="113"> <col style="width: 88pt;" width="117"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 85pt;" height="17" width="113">Original character</td> <td style="width: 88pt;" width="117">Changed character</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt;" height="17">a</td> <td class="xl63">e</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt;" height="17">b</td> <td class="xl63">v</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt;" height="17">c</td> <td class="xl63">d</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt;" height="17">d</td> <td class="xl63">I</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt;" height="17">e</td> <td class="xl63">z</td> </tr> </tbody></table>
I need two write two subs, Scramble and Unscramble. In each, ask the user for a message in an input box. In the Scramble sub, this will be an original message; in the Unscramble sub, it will be a scramble message. Then in the Scramble sub, scramble the message and display it. In the unscramble sub, unscramble the message and display it.
I would appreciate any help or can anyone point me in the right direction.
Thank you