garypea123
Board Regular
- Joined
- Mar 16, 2020
- Messages
- 221
- Office Version
- 365
- Platform
- Windows
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.
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.