ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2003 (https://www.excelbanter.com/excel-programming/296195-excel-2003-a.html)

Todd Huttenstine[_3_]

Excel 2003
 
Hey guys

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

Does anyone have an opinion on Excel 2003?

Thank you
Todd Huttenstine



Edwin Tam

Excel 2003
 
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





All times are GMT +1. The time now is 01:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com