How to use VBA

  • Thread starter Thread starter Mark Brantana
  • Start date Start date
M

Mark Brantana

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
 
Back
Top