Excel VBA Input box tutorial – How to create number series using input box

Hello everyone this is an Excel VBA Input box tutorial on How to create number series using input box. Please go through the below detailed video tutorial for a better step by step instructions. This tutorial also offers the best example on For Next loop in excel VBA. The very important thing is that you can create number series with row and column gaps that is you could create 1 or more empty rows between the series. You cannot do this stuff with the default series dialog nor you can achieve this by dragging the series. Hence this is an awesome macro code that surely you will like. You can also use this for your macro project work. If you like this work please show me your support by subscribing my YouTube channel.

Copy the code below for creating number series down the rows using inputbox function:

Sub SeriesInRows()
Dim X, Y, A, B, N
X = InputBox(“Enter the Row Offset”, “(Optional) Empty cells between series”, 0)
A = InputBox(“Enter the starting number in the series”, “Starting Number”, 1)
B = InputBox(“Enter the ending number in the series”, “Ending Number”, 50)
For N = A To B
ActiveCell.Value = N
ActiveCell.Offset(X + 1, Y).Select
Next N
X = 0
Y = 0
End Sub

Copy the code below for creating number series across the columns using inputbox function:

Sub SeriesInColumns()
Dim X, Y, A, B, N
Y = InputBox(“Enter the Row Offset”, “(Optional) Empty cells between series”, 0)
A = InputBox(“Enter the starting number in the series”, “Starting Number”, 1)
B = InputBox(“Enter the ending number in the series”, “Ending Number”, 50)
For N = A To B
ActiveCell.Value = N
ActiveCell.Offset(X, Y + 1).Select
Next N
X = 0
Y = 0
End Sub

Click the link below to download the macro file

Click here to download the file

I am very sure that excel vba input box tutorial could be a best example for excel vba input box examples.