+ Reply to Thread
Results 1 to 4 of 4

Adjust table length by user input

  1. #1
    Registered User
    Join Date
    07-12-2018
    Location
    Durham, NC
    MS-Off Ver
    Office 365
    Posts
    29

    Adjust table length by user input

    I am trying have a user's input adjust the number of rows in a table. Ex: User inputs current age (e.g. 40) and wishes to know the results when age 70. While a different user's age is 35 and wishes to know results when age 75. How do I create a function which will expand or contract the table to match the user's input variables?
    Thank you

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

    Re: Adjust table length by user input

    You already have an open thread on this subject:with several suggestions.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    07-12-2018
    Location
    Durham, NC
    MS-Off Ver
    Office 365
    Posts
    29

    Re: Adjust table length by user input

    The suggestion did not create the desire result. May be more challenging than I thought.
    Thanks for the response.

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

    Re: Adjust table length by user input

    You should always respond to replies so that those trying to help are not left hanging. If the last response did not help, explain what it did/did not do.

+ 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. Table length by input
    By Gfsrch in forum Excel General
    Replies: 21
    Last Post: 07-14-2018, 08:28 AM
  2. [SOLVED] Adjust VBA macro for a fixed location and remove user input
    By spyac in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 12-21-2017, 09:11 PM
  3. Create Varying Table Length Detremined by User Input
    By kaseech in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-04-2017, 07:30 AM
  4. Length of User Input
    By sperry2565 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-10-2013, 05:19 PM
  5. Convert freeform user input and write to a fixed length text file
    By vijaymohan10 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-02-2013, 04:44 AM
  6. Need to adjust the length of data for accepted by input vba
    By kjsconv in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-31-2013, 01:05 PM
  7. user input diameter and length to part number
    By razali in forum Excel General
    Replies: 1
    Last Post: 12-14-2005, 03:20 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