Announcement

Collapse
No announcement yet.

cell value in a msgbox

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    Re: cell value in a msgbox

    Martin

    Try this.
    Code:
    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:
    Msgbox "here is the current count of inventory " & Worksheets("Sheet1").Range("A1001")
    Boo!

    Comment

    Working...
    X