VBA Form message box value will determine last row of column"C".

  • Hi All,




    I am new and need help before all my hair falls out.




    My problem I've encountered is almost solved but it is just not working and I can't figure out why.


    When the user opens up the Date Form, s/he should be able to fill in what date the product starts and how many item # he needs.


    Once run, the sheet will generate dates according to set formula.




    The item # will determine how many rows to populate in the sheet.


    <TextBox25> is the user's input value of number of items that determine the amount of dates populated.




    The item # column is offset by - 4.


    I am not sure if the while statement is even needed at all, where the Wend is placed, and where to place i = i - 4




    Please let me know if there is any information I'm missing.


    Thanks for all the help! Appreciate you all!!!







  • Welcome to the Forum. Please read the Forum Rules to understand how the Forum works and why I have added Code Tags to your post


    All VBA code posted in the forum must be wrapped in code tags, which you omitted, including single-line code snippets.Be sure to use them in future posts.


    How to use code tags


    Just highlight all of the code and press the <> in the post menu above button to add the code tags.


    Thanks.

  • rory

    Changed the title of the thread from “NEED HELP - VBA Form message box value will determine last row of column"C".” to “VBA Form message box value will determine last row of column"C".”.