Excel (no matter which version) does not compile the VBA code in real time

If the syntax of a statement is wrong, VBA Editor reports a Compile Error when the VBA Project is being compiled

Therefore, if you simply type any text into a macro, VBA Editor won't report an error immediately. You can
1) try to run the macro, o
2) From the Debug menu, choose "Compile VBAProject
VBA Editor will then report an error

(2) force compile the VBA Project and the syntax of all macros in the project will be checked

Regards
Edwin Ta


This behavior has not been changed in Excel 2003


----- Todd Huttenstine wrote: ----

Hey guy

I installed Excel 2003 on my computer 2 weeks ago. It seems kind o
unstable especially when it comes to making and drawing tables. Also i
there anything wrong with my VBA In it because if while in any sub I typ
type any word such as the word "test" on a line by itself, I dont get a
error. I thought on previous versions of Excel if I typed a word on a lin
byitself, it would turn red. I cant remember but thats what I though
happened

Does anyone have an opinion on Excel 2003

Thank yo
Todd Huttenstin