#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 68
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default 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




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 49
Default 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




.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 versus Excel 2003 & Excel 97-2003 fully compatible Bumpersnesty Excel Worksheet Functions 0 April 26th 10 09:44 PM
importing/linking data from an Access 2003 Query to an Excel 2003 PerryK Excel Discussion (Misc queries) 2 August 24th 09 07:06 PM
Convert Excel 2003 spreadsheet into Outlook Contacts table 2003 Stuart[_4_] Excel Discussion (Misc queries) 2 October 6th 08 05:07 PM
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message [email protected] Excel Discussion (Misc queries) 0 July 10th 06 03:07 PM
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. Cindy Winegarden Excel Discussion (Misc queries) 0 November 28th 04 12:07 AM


All times are GMT +1. The time now is 09:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"