Really need help creating pop ups

[mward77095]

How do I create a pop up in window that will ask a question and have
blank spot for the answer?

Then, I want that answer to populate a database.

Please help. I'm pulling my hair out... and don't have many left

 

[abmorgan]

Use the InputBox function in Excel VBA
assign a value to the answer, for example

Sub InputBoxExample()
x = InputBox("How Old Are you?", "Age")
Range("A1").Value = x
End Sub

This procedure displays an input box and then enters the value into
cell A1.
you can pick any cell you like.

somethinglikeant

 

[mward77095]

Ok, I think this is exactly what I'm looking for, but I know nothin
about VBA. How do I get the box to pop up automatically, and then hav
the next one pop up etc.

 

[somethinglikeant]

just add another inputbox function such as

Sub InputBoxExample()
x = InputBox("How Old Are you?", "Age")
y = InputBox("Are you a fan of the band Shack?","Shack")
Range("A1").Value = x
Range("A2").Value = y
End Sub

somethinglikeant