Excel and its Visual Basic IDE

[TJMonti]

I am new to this so forgive me if this is a stuped question!
Q1
Is there a way to make the code colors dialog box, in the editor
format tab, of the tools menu, under the options selection, of the
Excel Visual Basic IDE so it is the same as the same as the box
in the Visual Basic Express Edition?
Q2
Is there a way to use the Visual Basic Express Edition in the
place of the Excel Visual Basic IDE?

 

[Jacob Skaria]

VBE within MSOffice applications is designed to support VBA with the
corresponding environment Excel/Word etc;;;

About Excel VBE http://www.cpearson.com/excel/vbe.aspx

If this post helps click Yes

 

[Bob Phillips]

1. Yes, goto Tools>Options>Editor Format

2. Not directly. You can write in VB Express and with (a lot) of work create
Excel addins, but it is Vb.Net not VB, so you cannot use directly.

 

[TJMonti]

Wow Thanks for the info and the site ref Jacob
the info will be put to good use I think

 

[TJMonti]

Thank you two Bob
--
TJMonti

1. Yes, goto Tools>Options>Editor Format

2. Not directly. You can write in VB Express and with (a lot) of work create
Excel addins, but it is Vb.Net not VB, so you cannot use directly.

--
__________________________________
HTH

Bob