The Most Simple Question Ever

[Angyl]

Hi, I'm not exatly new to VBasic, I've spent some time working with it in
Word (forms) but NEVER in Excel, and now it's time for me to get started
knowing how to work in Excel.

So the basic question is, how do I reference cells in vBasic (Excel?)

For example, how would I write:

If (cell A1) = "test" Then
(cell D24) = "It worked!"

This fundamental knowledge along with what I know from Word ought to be
enough to get me started on some projects...

Thanks!

 

[JE McGimpsey]

XL cells are Range Objects. One way:

If Range("A1").Value = "test" Then _
Range("D24").Value = "It worked"

An alternative:

If Cells(1, 1).Text = "test" Then _
Cells(24, 4).Value = "It worked"

 

[JLGWhiz]

This site provides some pretty basic information. It will at least help you
to understand some of the conventions and the language.

http://www.excel-vba.com/excel-vba-contents.htm

 

[Angyl]

Thank you both!

This site provides some pretty basic information. It will at least help you
to understand some of the conventions and the language.

http://www.excel-vba.com/excel-vba-contents.htm