Results 1 to 4 of 4

VBA Crypto solving

Threaded View

  1. #1
    Registered User
    Join Date
    07-20-2012
    Location
    Hawaii
    MS-Off Ver
    Excel 2007
    Posts
    2

    VBA Crypto solving

    I am trying to solve some simple crypto, that looks something like this;

    cells 1,1 has the alphabet and cells 1,2 has the key.
    a = z
    b = y
    c = x

    this is my long drawn out code for 1 cell.

    If Cells(1, 3) = "A" Then
        Cells(1, 3) = Cells(1, 2)
    ElseIf Cells(1, 3) = "B" Then
        Cells(1, 3) = Cells(2, 2)
    ElseIf Cells(1, 3) = "C" Then
        Cells(1, 3) = Cells(3, 2)
    ect...

    is there an easier way? please help.

    Thank you,

    Sean
    Last edited by Cutter; 07-20-2012 at 10:33 PM. Reason: Added code tags

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1