View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Cliff[_4_] Cliff[_4_] is offline
external usenet poster
 
Posts: 2
Default Easy Question: Cell Value

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