+ Reply to Thread
Results 1 to 2 of 2

Input box to select the column impacted by a macro

  1. #1
    Registered User
    Join Date
    07-12-2016
    Location
    massachusetts
    MS-Off Ver
    excel 2010
    Posts
    44

    Input box to select the column impacted by a macro

    Hi all,

    my current macro is:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    I'm looking to set up an input box for me to be able to select the column that has the criteria I'm adding the function to.

    The above macro adds a new column to the right of the target column (which holds an SSN that has no dashes), names it, takes cell 2 of that column, writes a formula to add dashes, drags it down to populate the rest of the cells in the range, copies/pastes as values, and then deletes the row it fed from so it becomes the column holding an SSN.

    I'm trying to make this a quick access button because this is a function I use extremely often. I'd love to have an input box precede the macro and request which column I'm looking to target (in this case column B).

    Any suggestions? I have no concept of how to do this.

  2. #2
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,412

    Re: Input box to select the column impacted by a macro

    Hi,

    Here's one suggestion.
    The code is simplified.

    TIP: you do not need to use 'Select' and 'Selection' as it slows down your code.

    Please Login or Register  to view this content.
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.

+ 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. Replies: 3
    Last Post: 09-23-2015, 02:30 PM
  2. Replies: 1
    Last Post: 03-20-2014, 09:35 AM
  3. [SOLVED] Basis on 1st column automatically select input for 2nd column from another worksheet
    By AasifKhan in forum Excel Formulas & Functions
    Replies: 27
    Last Post: 03-19-2014, 08:43 AM
  4. [SOLVED] input date column A, increment B, select blank cell in D and input time. in a macro
    By jeffstu in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-19-2012, 11:19 AM
  5. select column based on cell input
    By jcfrancisco in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-04-2011, 09:52 AM
  6. Select next column after data input into InputBox
    By Icanthearkinda in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-19-2009, 03:50 PM
  7. Select a column using the number from a input box?
    By comptechbranden in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-06-2007, 04:16 PM

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