cell value in a msgbox

  • Hi everybody,


    I would like to create a msgbox, which shows the value of one selected
    cell.


    for example:


    Msgbox "here is the current count of inventory (cell a1001)"


    In Excel, I am having trouble showing the value of cell "A1001" in the above mentioned msgbox.


    Any assistance will be truly appreciated.


    Sincerely,
    Martin

  • Re: cell value in a msgbox


    Martin


    Try this.

    Code
    1. Msgbox "here is the current count of inventory " & Range("A1001")


    This will show the value of A1001 in the active sheet, if you need to get it from another sheet you'll need to reference it.

    Code
    1. Msgbox "here is the current count of inventory " & Worksheets("Sheet1").Range("A1001")