Question Box

[Dazlancs]

Hi guys,

Need some help.

I need some VBA to create a pop up question box that will ask you a question with a part to input your answer and this then feeds in to a specific cell on the sheet (which will be referenced by the name manager)

Example would be:

What is your name?

You reply with Bob

The VB then puts the word Bob is cell named My_Name_Is

Thanks in advance
Darren

 

[gaj104]

Something like:

Range("My_Name_Is").Value = InputBox("What is your name?")

Hope it helps

 

[Kyle123]

Like this

Range("MY_NAME_IS").Value = InputBox("What is your Name?", "Enter your name")

 

[Kyle123]

Snap!

 

[Saracen628]

what is the criteria for causing the question to pop up?

Saracen

 

[Dazlancs]

Cheers guys - worked like a dream