Pop up Box so i can add a certain number in a certain cell

[zone709]

Hi trying to complete a vba code that I am working on. I need to add small vba pop box.

Need a pop up box saying "Enter check #" and the number I add will always go into cell E2.

Any help thanks

 

[Joe4]

At is very basic level, it would be something like this:

    checkNum = InputBox("Enter check #")
    Range("E2") = checkNum

You could add more to it if you wanted to validate the entries, etc.

 

[Scott T]

Try

Sub ckno()
cknum = InputBox("Enter check number")
Range("E2") = cknum

End Sub

 

[zone709]

NA This is fine thanks for the help