Collect user input to an array in VBA

Hi guys,

        How can I collect user input and store them to an array so that I can loop through the array to display the input?. The user will provide 40 inputs and the inputs will be entered into an array.

Thank you.

Parents
  • Thanks, guys. 

    But is it possible if the user can just input the data to just one input box and separate data with a comma?. 

    So just one input box that collects 40 values separated with a comma and each value is stored into an array.

    Thank you for your interest and help.

Reply Children
No Data