software

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: www.excelforum.com/member.php...oamp;userid=34240
View this thread: www.excelforum.com/showthread...hreadid=539992Use the InputBox function in Excel VBA
assign a value to the answer, for example

Sub InputBoxExample()
x = InputBox(quot;How Old Are you?quot;, quot;Agequot;)
Range(quot;A1quot;).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: www.excelforum.com/member.php...oamp;userid=34240
View this thread: www.excelforum.com/showthread...hreadid=539992just add another inputbox function such as

Sub InputBoxExample()
x = InputBox(quot;How Old Are you?quot;, quot;Agequot;)
y = InputBox(quot;Are you a fan of the band Shack?quot;,quot;Shackquot;)
Range(quot;A1quot;).Value = x
Range(quot;A2quot;).Value = y
End Sub

somethinglikeant