Excel and its Visual Basic IDE
 

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?
--
TJMonti

Excel and its Visual Basic IDE
 

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
---------------
Jacob Skaria


"TJMonti" wrote:

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?
--
TJMonti

Excel and its Visual Basic IDE
 

1. Yes, goto ToolsOptionsEditor 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

"TJMonti" wrote in message
...
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?
--
TJMonti

Excel and its Visual Basic IDE
 

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


"TJMonti" wrote:

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?
--
TJMonti

Excel and its Visual Basic IDE
 

Thank you two Bob
--
TJMonti


"Bob Phillips" wrote:

1. Yes, goto ToolsOptionsEditor 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

"TJMonti" wrote in message
...
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?
--
TJMonti