+ Reply to Thread
Results 1 to 4 of 4

EXCEL VBA input three parameters can produce different changes and order

  1. #1
    Forum Contributor
    Join Date
    09-01-2020
    Location
    bangladesh
    MS-Off Ver
    office 2007
    Posts
    167

    EXCEL VBA input three parameters can produce different changes and order

    Example 1
    Jump out of the input from there, the user enters C1 in the input window, then jumps out of the input window and enters C10, then jumps out of the input window and enters the interval, and enters 2, so EXCEL VBA will display C1 in A1, then C2 in A4, and then in A7, present C3, then at A10, presented C4, then at A13, presented C5, then at A16, presented C6, then at A19, presented C7, then at A22, presented C8, then at A25, presented C9, then at A28, presented C10

    Example 2
    Jump out of the input from there, the user enters D1 in the input window, then jumps out of the input window and enters D5, then jumps out of the input window and enters the interval, and enters 1, so EXCEL VBA will display D1 in A1, then D2 in A3, and then in A5, render D3, then at A7, renders D4, then at A9, renders D5

    Example 3
    From there, the user enters Y1 in the input window, enters Y5 in the input window, enters the interval in the input window, and enters 3, so EXCEL VBA will display Y1 in A1, then Y2 in A5, and then A9 , presenting Y3, then at A13, presents Y4, then at A17, presents Y5

    CODE NOT COMPLETE , I don't know how to write it. One code can complete three different tasks in examples
    Sub FillData()
    Dim startValue As String
    Dim endValue As String
    Dim increment As Integer
    Dim cell As Range
    Dim rowIndex As Integer
    startValue = InputBox("Please enter a starting value ")
    endValue = InputBox("Please enter an ending value ")
    increment = InputBox("Please enter the interval ")
    rowIndex = 1
    ?????????
    Next cell
    end sub

    Any help would be greatly appreciated!
    Attached Files Attached Files
    Last edited by rayhen; 06-14-2023 at 03:56 AM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,366

    Re: EXCEL VBA input three parameters can produce different changes and order

    Try

    Please Login or Register  to view this content.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Forum Contributor
    Join Date
    09-01-2020
    Location
    bangladesh
    MS-Off Ver
    office 2007
    Posts
    167

    Re: EXCEL VBA input three parameters can produce different changes and order

    WOW, JohnTopley you are amazing, it's amazing, Thank you so much

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,366

    Re: EXCEL VBA input three parameters can produce different changes and order

    You're very welcome and thank you for the rep.

+ 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. Recall data input in specific order in excel
    By godfreyschuller in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-30-2016, 03:15 PM
  2. i need a macro to produce three excel sheets for a data input sheet
    By Titan001 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-30-2016, 12:06 PM
  3. Replies: 3
    Last Post: 04-01-2013, 01:44 PM
  4. VBA to produce a unique and incremented order number in col A
    By lday75 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-26-2013, 02:59 PM
  5. macro for sendding mail via outlook and input parameters from excel sheet
    By ashayk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2011, 02:33 AM
  6. macro to produce purchase order data
    By stevesunfold in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 10-18-2008, 12:49 PM
  7. Input parameters to an excel Application
    By eitancoh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-22-2007, 06:35 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