Simple Macro won't Work

[waldos]

Im going nuts trying to learn this VBA
I have put a button on the tool bar with the following code
Sub CommandButton_Click
If B10 = A3 then
D1 = 2 else
D1 = 5
End If End Sub

Half hour later I still Can't get it to work.
What am I not doing?
Any help greatly appreciated

 

[Swamp Thing]

You can't use cell addresses (e.g. B2, C4) directly in vba. The entire excel application, consisting of workbooks, worksheets, cells, charts etc etc etc is visible to VBA as a hierarchical collection of objects. You have to manipulate excel's features using these objects and their properties.

For example, a group of cells is a "Range" object in VBA.

Your code will be like this (note use of range object):<pre>
Sub CommandButton_Click
If Range("B10") = Range("A3") Then
Range("D1") = 2
Else
Range("D1") = 5
End If
End Sub</pre>

To get started on your VBA adventure, try recording some macros of simple operations using the macro recorder (Tools > Macros > Record Macro) and study the resulting code.
This message was edited by Swamp Thing on 2002-09-04 01:51

 

[Jeff in Holland]

This was a great learning experience for me thanks! I do need a little explanation on something though, what does the ELSE do? I plugged the macro in and set A3 and B10 equal and it entered 2 in D1, but what does the else D5 do? Also, it ran once automatically, but after that I had to physically press the run button to get it to go. Is there a way to set it up so that it just runs continuously?