Msgbox that allows workbook interaction.

  • 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

  • Kabong,


    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.


    Allcare


    AJW



    Sub MYCellSelect()
    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")
    End Sub

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!