Microsoft Excel’s new text functions make working with strings a breeze. Image: IB Photography/Adobe Stock A common task is to parse or find characters within a delimited string in Microsoft Excel.

In the window that opens, go to the Input message tab. Check the box that says “Show input message when cell is selected.” Add a title (32 characters). Type your input message (255 characters).

How to use InputBox in VBA Now that you know about InputBox, let’s use it in a simple procedure. Specifically, the procedure in Listing A will prompt you to select a range. After a few value ...