+ Reply to Thread
Results 1 to 4 of 4

Input Box for Selecting Multiple Cells - Array

  1. #1
    Registered User
    Join Date
    10-03-2012
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    44

    Input Box for Selecting Multiple Cells - Array

    Hi All,

    I been stuck on this one part of my code.

    Please Login or Register  to view this content.
    My problem is that when the user selects several cells the code will act on the first selection and just copy that same selection to the number of cells the user clicked. For example, if the user clicked "111","112","113" I just see "111REV", "111REV", "111REV". I am bit shaky on how to utilize dynamic arrary for user input boxes to begin with.

    Any help would be greatly appreciated.

  2. #2
    Registered User
    Join Date
    10-03-2012
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    44

    Re: Input Box for Selecting Multiple Cells - Array

    I failed to mention that I am aware the following line does not work and returns an error. It was just one of my experimental scripts I tried to make this module work...

    Please Login or Register  to view this content.

  3. #3
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Input Box for Selecting Multiple Cells - Array

    Maybe something like this:-
    Please Login or Register  to view this content.
    Regards Mick

  4. #4
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Input Box for Selecting Multiple Cells - Array

    Duplicate !!!!!

  5. #5
    Registered User
    Join Date
    10-03-2012
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    44

    Re: Input Box for Selecting Multiple Cells - Array

    Thanks for the coding Mick; however, I want the user to be able to select all the cells they want paid back in the input box, so it would look like "A1","A2","A3" and then I want the "REV" added to the text in those specifc cells. Once the REV is added my code works fine from there.

    I thought an array would be useful, but as I stated above it only acts on the first selection.

+ 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. Cells selecting a word input depending on input of another cell
    By ceeje25 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-14-2012, 07:08 AM
  2. Selecting multiple cells in multiple columns and rows to paste into a single row.
    By Cyberpawz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-05-2012, 04:03 PM
  3. sum array - multiple criteria with the same input value
    By polacoloco in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-20-2010, 11:43 AM
  4. Selecting cells in a one line array
    By tperry in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-27-2007, 11:48 PM
  5. [SOLVED] selecting cells with an input box
    By Jordan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-02-2005, 01:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1