Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Where is Excel VBA Help Info?

Richard Winston wrote in news:o7Uyb.1155609$be.166508
@news.easynews.com:

"John Wilson" wrote in
:

Richard,

Why don't I have Excel VBA specific help info

There is no such thing. VBA is Visual Basic for Applications.
Excel is one of those "Applications"

your syntax error.
Your VBA Tools/Options are probably set to "Require Variable
Declaration" (which is a very good idea). Having this option selected
will place Option Explicit at the top of every module (which means
that all your variables
will have to be declared or you'll get an error).
I don't know what code Don gave you, but if you delete that top line
(Option Explicit), it should work. Better though would be to find
what variables that Don was using in the code he gave you and
declare them with a Dim statement.

John



Why don't I get context sensitive help for Excel objects. When I write
Outlook macros I am able to hilight "MailItem", for example, and get
help for that particular object. It's not working for me with the Excel
Macro that Don gave me (posted below)



Never mind, you were right. Now that I did what you suggested and got rid
of the Option Explicit, the code works and the context sensitive help
works.



Thanks.
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
i deleted info in excel then saved. can i recover deleted info? jbhtbruce Excel Discussion (Misc queries) 2 May 25th 10 08:54 AM
Move cell info and info in range of cells on new entry abc[_2_] Excel Discussion (Misc queries) 5 February 15th 10 08:21 PM
Copied info from Excel worksheet, but pasted info won't work in fo KRISTENV Excel Discussion (Misc queries) 3 January 8th 09 03:13 PM
Can I lock info in Excel 2003 and users in Excel 2000 enter info? Mimmsan Excel Discussion (Misc queries) 1 September 8th 05 12:12 AM
how do i get excel to see info in one cell, look at info in anoth. ditto Excel Discussion (Misc queries) 3 February 1st 05 04:37 PM


All times are GMT +1. The time now is 04:59 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"