I am used to using VB, which I am now learning. What I don't understand is
VBA. How do the objects you place on the desktop run if you never compile
anything. If I put a button, for example, on the desktop, I can write code
in it, but it still remains in the "form" mode.

Is there a step I need to know about to integrate this button with the
spreadsheet and make it work?

Mark

there are 2 types of controls in vba - form and activeX.
ActiveX can be programmed the same way as in VB. Just don't forget to switch
from design mode. Form controls are simpler, they can only run assigned
macro.

Form controls are on the Form toolbar, ActiveX - on Control ToolBox toolbar.

RADO


"Mark Brantana" wrote in message
nk.net...
I am used to using VB, which I am now learning. What I don't understand
is
VBA. How do the objects you place on the desktop run if you never compile
anything. If I put a button, for example, on the desktop, I can write
code
in it, but it still remains in the "form" mode.

Is there a step I need to know about to integrate this button with the
spreadsheet and make it work?

Mark