ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2003 (https://www.excelbanter.com/excel-programming/296187-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



Chip Pearson

Excel 2003
 
Todd,

I don't know about drawing tables (what, exactly, do you mean by
"drawing tables"), but VBA doesn't and shouldn't raise an error
if you enter a single word (assuming it isn't a reserved word
or ) on a line of code. VBA interprets this to be the name of a
function declared elsewhere. It will raise a compiler error if
no such function exists, but it doesn't raise an error as you
type in the code. This is the behavior in all versions of VBA.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"Todd Huttenstine" wrote in message
...
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





SidBord

Excel 2003
 
I agree . . . a single word shouldn't trigger an error.
I have a question for you now. I also just started using
Excel 2003, and I have a puzzeling problem: My wheel mouse
won't scroll in any of the windows associated with Visual
Basic. It works just fine elsewhere. It's driving me
cookieputz! No one seems to know why, except there has
been some mention of a Universal Scrolling List and
exceptions thereto. So far I have been unable to find it.
Are you experiencing any scrolling problems?
-----Original Message-----
Todd,

I don't know about drawing tables (what, exactly, do you

mean by
"drawing tables"), but VBA doesn't and shouldn't raise an

error
if you enter a single word (assuming it isn't a reserved word
or ) on a line of code. VBA interprets this to be the name

of a
function declared elsewhere. It will raise a compiler

error if
no such function exists, but it doesn't raise an error as you
type in the code. This is the behavior in all versions of VBA.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"Todd Huttenstine" wrote in

message
...
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




.



All times are GMT +1. The time now is 11:49 PM.

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