+ Reply to Thread
Results 1 to 5 of 5

Convert InputBox to known range

  1. #1
    Registered User
    Join Date
    03-12-2019
    Location
    Chicago
    MS-Off Ver
    2016
    Posts
    8

    Convert InputBox to known range

    Hi All, I want to use the code below that I found because it works really really well for my application. However I am wasting a lot of time because I already know my input and output. I was hoping to shorten this so I dont have to enter the data each time

    Input: Workbooks("name"").Workseets("Name").Sheet(1).Range("$L3:$N396")
    Output (different workbook): Workbooks("Name2").Sheet(2).Range($A1)

    The code that I have:
    Please Login or Register  to view this content.
    Last edited by Chares603; 04-11-2019 at 12:09 AM.

  2. #2
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: Convert InputBox to known range

    Like this?
    Please Login or Register  to view this content.
    And delete
    Please Login or Register  to view this content.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    03-12-2019
    Location
    Chicago
    MS-Off Ver
    2016
    Posts
    8

    Re: Convert InputBox to known range

    Thanks a ton! it worked!

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,323

    Re: Convert InputBox to known range

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


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: Convert InputBox to known range

    Thanks for the feedback

+ 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] Use Range from InputBox Repeatedly
    By myou in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-09-2016, 01:41 PM
  2. [SOLVED] MACRO: If user clicks cancel in inputbox,then do nothing. Problem with inputbox appearance
    By Tona in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-05-2015, 04:33 AM
  3. [SOLVED] Help with InputBox for Date Range
    By george.arnold in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-10-2015, 12:19 PM
  4. Replies: 0
    Last Post: 05-22-2013, 05:57 AM
  5. [SOLVED] Select range with InputBox. Is it possible?
    By Isabel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-13-2013, 06:36 AM
  6. [SOLVED] Select range via Inputbox
    By nakul2617 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-21-2013, 07:46 AM
  7. [SOLVED] Inputbox Convert Millimeters to Feet and Inches
    By RShow in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-23-2005, 04:05 AM

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