Is there a way to make a msgbox that allows the user to interact with the workbook while it is still popped up? I want to prompt the user to paste data into a specific area of the workbook and then click ok when they are done. The standard msgbox will not allow the user to click on the workbook. Is there a special type like there are in inputboxes?
I don't think you can achieve this with a messagebox. You could perhaps create a modeless Userform. Create a Userform with your message and then in the Properties Window find Show Modal and set this property to False
Note: Modeless userforms are only possible in Excel 2000 and above.
Why not stick with the input box?
The attached code allows you to select a range that will be used, or as you put it "to prompt the user to paste data into a specific area of the workbook".
Once the OK is clicked code is returned to and executed on the location of choice.
Hope this helps.
On Error Resume Next
Dim mycell As Range
Set mycell = Application.InputBox(prompt:="Select Cell to enter value. ", Title:="Value Location", Type:=8)
Application.Range(mycell.Address).Value = ("Hello - " & " 100 " & "bonus points")