+ Reply to Thread
Results 1 to 2 of 2

Review previous written codes used on another file, and rewrite for this program

  1. #1
    Forum Contributor Potholes's Avatar
    Join Date
    MS-Off Ver
    Excel 2016, Excel 2019

    Review previous written codes used on another file, and rewrite for this program

    Hi All

    To moderator's if my " Title " does not comply PLEASE advise.

    I have a variation on my Word finder program, this one has a set of clues which will be on the " Finder sheet" cells B21 to R26

    I am using the same coding that Justin wrote, which is what I would like modified to suit this particular program.

    1/ On the "Finder" sheet cell B1 shows the words obtained and what the remainder is left to find which will reside on the
    " Clues " sheet Cell A1, which will contain all the words that will be available.

    2/ On " Finder" cell B2 is a command button that when you highlight the found word, it Highlight the word with the colour as in
    " Finder" Cell F1, then moves that word from the "Clues " dictionary and sends it to "Finder" Cell B27, and adjusting the word
    counter on "Finder" cell B1, then places the last word found in "Finder" Cell F3.

    3/ The 2 Command buttons in "Finder" in cells J,K,L, are functioning AOK.

    4/ On the "Finder" Cell M1 the word sorter command needs attention.

    I hope I have given enough information.


    Thank you to anyone that looks at this thread.


    Posted elsewhere
    Attached Files Attached Files
    Last edited by Potholes; 06-11-2020 at 04:53 AM.
    One I have learnt over the last few months, " You are NEVER too old to learn ".
    Sometimes I forget to say " Thank You " for your assistance, so here I say " A BIG Thank You. "

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)

    Re: Correct VBA codes to carry out instructions in this new program

    No, the title isn't good enough - instructions to do what??? Please update it with more specifics. Thanks.

    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Have I got this under the correct change program?
    By bralew in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-14-2016, 10:37 AM
  2. [SOLVED] finding the correct codes
    By marj0909 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-28-2016, 08:11 PM
  3. Disappearing cell Instructions- can't get codes to work....
    By amp2020 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-12-2014, 04:05 PM
  4. Screening formula to flag correct zip codes
    By pgiger in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-30-2012, 03:31 PM
  5. Replies: 1
    Last Post: 12-16-2007, 06:44 PM
  6. [SOLVED] Instructions to convert columns to rows Excel help are not correct
    By Excel 2003 Columns to rows in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-15-2006, 02:50 PM
  7. [SOLVED] how do you read a visual basic program codes
    By jaydee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-09-2006, 08:10 AM


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