VBAString Tip 6: Input Box In Excel VBA To Add A Sequence

In this tip will use VBA To add a sequence of months to a worksheet with the input box

First add the following code to a button called “Button1″‘s click event:

In the first image, I am using the VBA inputbox to accept a date entry:

excel_input_box_sequence_1

In the following image I am asking the user to confirm their date entry using the VBA msgbox :

excel_input_box_sequence_2

If the selection is positive, I am using the DateAdd function, to keep on adding a month according to my loop count.

Also since I am writing to the columns of the worksheet in the first row, which are alpha characters instead of numeric (like the rows), I use “Cells()” which takes the column index instead of the alpha (A-XFD) name like “Range()”,as shown in the following image:

excel_input_box_sequence_3

Watch it in action:

****************************************************


 

Let me know if you have any questions

I consent to having this website store my submitted information so they can respond to my inquiry. See our privacy policy to learn more how we use data.
 

Please remember to subscribe to my youtube channel

Been helped? Get these!

Facebooktwittergoogle_plusredditpinterestlinkedinmail