Really need help creating pop ups
 

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

Really need help creating pop ups
 

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

Really need help creating pop ups
 

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

Really need help creating pop ups
 

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