Excel Hack 72: Creating input prompts in MS Excel (the Input Box feature)
This is a short post introducing a feature in Excel VBA that enables you to update the contents of any cell through an input box. Just as demonstrated above. The Input Box is an Excel VBA feature. It can be introduced in macros to request for input from the user to complete an automated task.