+ Reply to Thread
Results 1 to 6 of 6

Select 1 of 50 cells

  1. 11-21-2020, 04:31 AM #1
    Cabby205
    Cabby205 is offline
    Registered User
    Join Date
    03-11-2011
    Location
    Nova Scotia, Canada
    MS-Off Ver
    Excel 2016
    Posts
    17

    Select 1 of 50 cells

    manually, Character Names 1 thru 5 are deleted. At top of wsheet are 50 enemies, enemy pic in one cell, name of enemy directly below. Click on first enemy name, character name #1 is filled in, click on second enemy name, character name #2 is filled in, etc, a total of five times.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-21-2020, 04:43 AM #2
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,299

    Re: Select 1 of 50 cells

    Hi Cabby205

    Welcome to the forum...
    This should get you started...
    Please Login or Register  to view this content.
    Or No loop...
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by sintek; 11-21-2020 at 04:56 AM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  3. 11-21-2020, 04:56 AM #3
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,940

    Re: Select 1 of 50 cells

    Place this code in the Worksheet Events not in the standard Workbook module.

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  4. 11-21-2020, 05:00 AM #4
    Cabby205
    Cabby205 is offline
    Registered User
    Join Date
    03-11-2011
    Location
    Nova Scotia, Canada
    MS-Off Ver
    Excel 2016
    Posts
    17

    Re: Select 1 of 50 cells

    Works perfectly. Thank you. How do I indicate Solved?
    Reply With QuoteRegister To Reply
  5. 11-21-2020, 05:01 AM #5
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,940

    Re: Select 1 of 50 cells

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    Reply With QuoteRegister To Reply
  6. 11-21-2020, 05:03 AM #6
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,299

    Re: Select 1 of 50 cells

    Slight modification to ensure that characters are not duplicated...
    Please Login or Register  to view this content.

    THANKS.gif
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Randomly Select Cells In Column That Contain Data - Skip The Blank Cells
    By Logit in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-18-2018, 07:54 AM
  2. [SOLVED] How to select 3 cells, transpose, loop to select next 3 cells.
    By Hood in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-02-2017, 02:07 PM
  3. excel using VBA how to select specefic cells based on their values and copy these cells in
    By devleb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-14-2015, 04:09 AM
  4. Mouse click to select two cells, and have the contents of those cells output elsewhere
    By porko5079 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-11-2015, 01:05 PM
  5. Formatting cells other than select-highlighting the cells to apply the format?
    By Joe Miller in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-27-2014, 10:53 AM
  6. [SOLVED] Using code to select cells that are two cells to the left of the currently active cell
    By LaffyAffy13 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-25-2013, 01:56 PM
  7. macro to select cells based on status of cells to left
    By dcbiker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-03-2011, 05:15 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1