View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default Subrouines and graphics in VBA

Sub Test1()
Msgbox "In Test1"
Test2
Msgbox "Back in Test1"
End Sub

Sub Test2()
Msgbox "In Test2"
End Sub

You can use shapes for simple graphics - see the drawing toolbar. Draw some shapes while recording a macro to get some idea of what
you code might look like.

--
Tim Williams
Palo Alto, CA


"stuart" wrote in message ...
I'm using VBA (Visual Basic 6.3) in Excel 2002.

Can I use VBA to write a program that is made up from a series of
subroutines, or the VBA equivalent? I remember using CALL in FORTRAN years
ago, but what is the corresponding VBA syntax?

Also, can VBA produce simple graphics (this could be a little difficult to
explain). For example as an output from a VBA program a simple diagram is
produced, such as lines, 2-D planes and cylinders. I'm not sure if VBA has
any graphics abilities.

Thanks.