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

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • 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.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!