I've programmed vba in access before but not Excel. I simply want to create
a msgbox that shows the value of a cell.

Example

sheet1:

A B C
1 Value No No
2 No No No

code:

msgbox A1

does not return the referenced value. Just blank (triggering off a command
button).

Sorry for such a nobb question....But thanks!

Robert

On Feb 7, 10:46*am, Robert_DubYa
wrote:
I've programmed vba in access before but not Excel. *I simply want to create
a msgbox that shows the value of a cell.

Example

sheet1:

* * * * * A * * * * *B * * * * *C
1 * * Value * * * No * * * *No
2 * * * *No * * * *No * * * *No

code:

msgbox A1

does not return the referenced value. *Just blank (triggering off a command
button).

Sorry for such a nobb question....But thanks!

Robert

MsgBox Sheets("Sheet1").Range("A1")

msgbox activeworkbook.worksheets("sheet99").range("a1").v alue
or
msgbox activesheet.range("x99").text 'if it's formatted nicely.



Robert_DubYa wrote:

I've programmed vba in access before but not Excel. I simply want to create
a msgbox that shows the value of a cell.

Example

sheet1:

A B C
1 Value No No
2 No No No

code:

msgbox A1

does not return the referenced value. Just blank (triggering off a command
button).

Sorry for such a nobb question....But thanks!

Robert

--

Dave Peterson

If the cell you want the msgbox to display is the activecell then maybe:

msgbox activecell.value

--
JB


"Robert_DubYa" wrote:

I've programmed vba in access before but not Excel. I simply want to create
a msgbox that shows the value of a cell.

Example

sheet1:

A B C
1 Value No No
2 No No No

code:

msgbox A1

does not return the referenced value. Just blank (triggering off a command
button).

Sorry for such a nobb question....But thanks!

Robert