Scramble and Unscramble a message

**natygrosso** · 03-11-2010, 09:16 PM

Hi,

I have an excel file like this with all the alphabet letters:

Original character Changed character
a e
b v
c d
d I
e z

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

**Paul** · 03-12-2010, 01:44 AM

Hi Natygrosso,

Please review the updated spreadsheet. Click the Scramble button to enter normal words and have them scrambled based on the value conversion from column A to B. Click the Unscramble button to enter a scrambled message and perform a conversion from column B to A.

The way this is setup is that when scrambling a letter it looks for the letter in column A and returns the "changed character" from column B. When unscrambling, it looks for the letter in column B and returns the "original character" from column A.

For example:
Scramble the word "Paul" and you get "Iewq"
Unscramble the text "Iewq" and you get "Paul"

You could set it up another way, such that it looked for the letters "Iewq" in column A and returned new changed characters from column B, but that could get confusing (especially if you're trying to get back to the original word/phrase).

The Scramble and Unscramble macros only differ by one line, and there are probably easier ways to do this than using Dictionary Scripting Objects and an array... but Leith helped me with a word/character replacement macro several weeks ago using this method, and I wanted to take some time to try to write one myself.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hope that helps!

**Paul** · 03-12-2010, 02:17 AM

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

**ravishankar** · 03-12-2010, 03:46 AM

HI
it is certainly distressing to find the time and effort spent on finding a solution has been misspent.
See the attached file for my approach to the problem
Ravi

**teylyn** · 03-12-2010, 04:03 AM

ravishankar: Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc

**natygrosso** · 03-12-2010, 09:58 AM

I want to apologize to everyone that got affected by my mistake. I didn't mean any harm or wasting anyones time. It was plain ignorance on the forum subject. I assure that the lesson was learned and it would never happen again.Thank you very much for everyones help it is greatly appreciate it.
Thank you

Naty