It all depends on what your application does.
As it sounds like a big project with big money I think it is definitely
worth buying the book:
Professional Excel Development, by Bullen, Bovey and Green.
There are nearly 100 pages about using VB with Excel.
I have only just started with this, but found already good use for it,
namely to transfer VBA code
to ActiveX dll's for speed (up to about twice as fast) and code protection.
The other big advantage I can see is to use VB userforms in Excel.

RBS


"Mark Stephens" wrote in message
...
I am a self taught excel programmer and am embarking on development of
software for mass worldwide distribtion. Is there any reason why i should
consider using VB (which I have never used) over VBA within excel. Seems to
me excel can do everything I need and I understand that even if I were to
switch to VB my users will still have to have excel to use the program, so
is there any benefits in switching?

Sirry it's a pretty basi cquestion but there doesn't seem to be much info
on google on the subject.

Thanks and regards, Mark Stephens