Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Programmatic access to visual basic project via Visual FoxPro | Excel Programming | |||
Can I run Visual Basic procedure using Excel Visual Basic editor? | Excel Programming | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) | |||
visual basic in excel - | Excel Discussion (Misc queries) | |||
excel/visual basic | Excel Programming |