Tuesday, November 15, 2016

Insert Sequence Numbers Quickly With Macro

Creating Multiple Inputbox With Excel Vba          
          The sequence numbers can be added into the wished column with macro. When the button on the page is clicked, macro starts running .Input boxes  are opened in sequence.
.Input boxes ask the questions to the user.
          The sequence numbers are added to the selected column according to the answers given by the user.


Codes of input boxes :
cevap1 = InputBox("Please ,Select The Column You Want To Enter The Sequence Numbers." & vbNewLine & vbNewLine & _
"Column Numbers and Their's Letters" & vbNewLine _
& vbNewLine & "1 -> A                10 -> J                19 -> S" _
& vbNewLine & "2 -> B                11 -> K                20 -> T" _
& vbNewLine & "3 -> C                12 -> L                21 -> U" _
& vbNewLine & "4 -> D                13 -> M                22 -> V" _
& vbNewLine & "5 -> E                14 -> N                23 -> W" _
& vbNewLine & "6 -> F                15 -> O                24 -> X" _
& vbNewLine & "7 -> G                16 -> P                25 -> Y" _
& vbNewLine & "8 -> H                17 -> Q                26 -> Z" _
& vbNewLine & "9 -> I                18 -> R                ........" _
& vbNewLine & vbNewLine & "Press OK Button After Writing Your Answer .", "COLUMN", "1")

cevap2 = InputBox("Which Rows to Begin?" & vbNewLine & vbNewLine & _
"Press OK Button After Writing Your Answer .", "Row", "2")

cevap3 = InputBox("Enter The Sequence Number to Begin From Which Number." & vbNewLine & vbNewLine & _
"Press OK Button After Writing Your Answer .", "The Number Of Start", 1)

excel vba multiple inputbox