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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA copy and paste data 2
How To Use External VBA Custom Function In Excel ? 1
How to use Excel VBA Help 1
Generic file path using vba 2
VBA to VB6 6
HELP: how to locate objects on userform from VBA code 2
Vba tips and help 5
VBA CODE HELP! 0

Back
Top