VBA prompt box to add text to a cell.

[garypea123]

Good Morning,

I have a VBA running and I would like to create a prompt box where it asks for an input say in Cell C3 for a number (below example is age)

So the VBA should show a message when run to say "Please enter Gary's Age". I then type the number into the prompt box, and this answer goes into C3. Then I do the same for D4 but with the command "Please enter Tom's Age"

The rest of my script will then run as normal based on these results..

Hopefully this makes sense.

 

[mohadin]

What about

Range("C3") = InputBox("Please Enter " & Range("B3") & " Age")
Range("C4") = InputBox("Please Enter " & Range("B4") & " Age")

 

[garypea123]

Works an absolute dream, makes it look very professional, and such a simple and easy script. Thank you ever so much

 

[mohadin]

You are welcome
And thank you for the feedback
Be happy & safe