+ Reply to Thread
Results 1 to 4 of 4

Change VBA code using input box

  1. #1
    Registered User
    Join Date
    05-28-2014
    Posts
    67

    Change VBA code using input box

    Hi all,

    Please help!

    I'm having a difficult time trying find a way to change the bolded values using an input box instead of manually changing "intR = intS To value" for the cells that I need the code to look at.


    Please Login or Register  to view this content.
    I am noobie to coding and any amount of help is greatly appreciated! Thank you!!!
    Last edited by LLL0422; 05-28-2014 at 03:11 PM.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Change VBA code using input box

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,629

    Re: Change VBA code using input box

    Please Login or Register  to view this content.
    Ben Van Johnson

  4. #4
    Registered User
    Join Date
    05-28-2014
    Posts
    67

    Re: Change VBA code using input box

    Thank you so much!! That did the trick!

+ 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] Input code on one page --> correct input on the other
    By jacksoss in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-15-2012, 01:25 AM
  2. Replies: 2
    Last Post: 06-11-2012, 07:30 PM
  3. Changing code from Manual input to Calculated input
    By Gertheking in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-16-2012, 11:41 AM
  4. Doing away with an Input box - how to change this code?
    By HankMcSpank in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2009, 09:22 AM
  5. Replies: 1
    Last Post: 09-29-2005, 08: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