Easy Question: Cell Value

[Robert_DubYa]

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

 

[Cliff]

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")

 

[Dave Peterson]

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

 

[john]

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

msgbox activecell.value