How do I create a pop up in window that will ask a question and have a
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.


--
mward77095
------------------------------------------------------------------------
mward77095's Profile: http://www.excelforum.com/member.php...o&userid=34240
View this thread: http://www.excelforum.com/showthread...hreadid=539992

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

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


--
mward77095
------------------------------------------------------------------------
mward77095's Profile: http://www.excelforum.com/member.php...o&userid=34240
View this thread: http://www.excelforum.com/showthread...hreadid=539992

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