ID: Q162320
The information in this article applies to:
This article shows you how to obtain support information from the Microsoft Knowledge Base by e-mail or by fax. If you are currently viewing this article on the World Wide Web, this information may not pertain to you.
The "Article Listing" section of this article includes a subset of Knowledge Base articles about using Visual Basic for Applications in Microsoft Excel 97. Use the instructions in the "Ordering Articles by E- Mail or by Fax" section of this article to order items from this list.
Note that because Microsoft Technical Support is constantly adding new information to the Knowledge Base, not all articles are listed here. For this reason, you may want to look on the Web to find the information you are looking for. Microsoft Technical Support on the Web is located at the following address on the World Wide Web:
http://support.microsoft.com/support/default.asp
To have an article from the list sent to you in e-mail, send a message to "mshelp@microsoft.com" (without the quotation marks), and use the Article ID in the subject line of the message, as in the following example:
TO: mshelp@microsoft.com
SUBJECT: Q119591
mshelp@microsoft.com
To have an article sent to a fax machine, use the Microsoft FastTips System. Microsoft FastTips is available 24 hours a day, 7 days a week, from a touch-tone telephone. To order items from this article list, first note the five- to six-digit number of the Article ID shown for each item, and then follow these steps:
1. Dial the toll-free FastTips number:
(800) 936-4100
using (for example, for Microsoft Word, select 2).
4. From the "FastTips Main Menu," select 1 to place a FastTips catalog
order.
6. When prompted with the "at the tone, enter the item ID number followed
by the pound key" message, enter the Article ID number from the
following list and press # (use the numbers following "Q," but do not
include "Q").
NOTE: You can order up to five items at a time.
code and seven-digit fax number.
If you have problems receiving a fax, please call the FastTips Hotline at (425) 635-3199.
ARTICLE ID ARTICLE TITLE
Q143452 XL97: MS Excel Hangs When You Programmatically Save a Workbook
Q143458 XL97: Cannot Move or Copy Sheet After Last Sheet
Q143460 XL97: Overflow Error Occurs When Using Err Object
Q143461 XL97: CreateObject and GetObject Work Differently
Q156353 XL97: No Menu Choice to Select All Hyperlinks
Q156450 XL97: No Info Window in Microsoft Excel 97
Q156879 XL97: Visual Basic Modules Cannot Be Hidden or Protected
Q156880 XL97: Using the MenuBars Method in Microsoft Excel 97
Q156882 XL97: Err Msg: "Name Conflicts with Existing Module"
Q156942 XL97: How to Create an Add-in File in Microsoft Excel 97
Q156943 XL97: How to Convert an Add-in File into a Workbook
Q157090 XL97: Background Queries Suspended While Macro Executes
Q157095 XL97: Natural Language Formulas Return Error
Q157096 XL97: SendKeys Slower When Compared to MS Excel 7.0
Q157101 XL97: F1 in Custom XLM Dialog Box Displays Office Assistant
Q157102 XL97: EnableSelection Property May be Overridden
Q157103 XL97: Macro Stops Running When its Workbook is Closed
Q157104 XL97: Errors When Trying to Make Office Assistant Visible
Q157105 XL97: Worksheet_Change Does Not Run When Worksheet Sorted
Q157107 XL97: "Type Mismatch" Comparing String Variable to Boolean
Q157108 XL97: Options not Available in Macro Options Dialog Box
Q157110 XL97: Problems When Selecting Error Bars With a Macro
Q157113 XL97: "Invalid Use of Null" Error Setting OnRepeat Method
Q157124 XL97: Styles("X").Parent Different Than in Earlier Versions of Excel
Q157202 XL97: Color Palette Looks Different in Microsoft Excel 97
Q157203 XL97: Cannot Add Macros to the Tools Menu
Q157304 XL97: Cannot Drag UserForm Control Onto a Worksheet
Q157306 XL97: Len Function Returns Only 1024 Characters in Cell
Q157308 XL97: Calling RunAutoMacros Method More than Once Fails
Q157311 XL97: Problems with Recorded Macro That Creates Map Object
Q157313 XL97: Unable to Show UserForms in Other Projects
Q157315 XL97: Copy From Object Browser May Not Copy Named Arguments
Q157316 XL97: Macro Error Using ActiveCell in a Binder File
Q157319 XL97: Problems When you use Macro to Add Control to UserForm
Q157320 XL97: Macro Can't Open File That Has no Extension
Q157346 XL97: Code "Behind" Worksheet or Workbook May Not Work
Q157347 XL97: Change in ADD.MENU Macro Position Argument
Q157349 XL97: Can't Access File List and Window List Menu Items
Q157350 XL97: Text Property Limited to 1024 Characters
Q157351 XL97: Compile Error Passing ParamArray
Q157407 XL97: Error Passing Objects to Subroutine
Q157411 XL97: Error Message for Sheets.Select Has Changed
Q157412 XL97: Select Method May Select More Cells Than Expected
Q157415 XL97: TabStrip Information Missing from Value Property Help
Q157416 XL97: How to Assign a Macro to an ActiveX Worksheet Control
Q157436 DAO 3.0 CopyFromRecordset Method Not Compatible With XL97
Q157471 XL97: Run-Time Error Using CreateObject With DAO.DBEngine
Q157553 XL97: Dialog Boxes and UserForms Use Tahoma Font
Q157554 XL97: RefEdit Control in Binder Does Not Collapse
Q157555 XL97: UserControl Property Code Example Doesn't Work Properly
Q157556 XL97: Problems When Removing Line from Drawing Object
Q157558 XL97: Chart Activation with Macro Changes Selection
Q157609 XL97: How to Display a UserForm Whose Name Is in a Variable
Q157611 XL97: Menubars and Toolbars Flash When You Close a Workbook
Q157653 XL97: Button Format Carries Over to MS Excel 5 Dialog Sheet
Q157754 XL97: Problems When Disabling/Enabling Menus in MS Excel 97
Q157755 XL97: Using "Checked", "Gray", and "Unchecked" in Macros
Q157758 XL97: Clicking Cancel Button May Not Dismiss UserForm
Q157940 XL97: How To Create a Dynamic Chart Using Visual Basic
Q157951 XL97: OnSave Property Not Available in Object Browser
Q157958 XL97: No "Record at Mark" Feature in Microsoft Excel
Q157986 XL97: Unexpected Behavior for RefEdit Control in Binder
Q158066 XL97: Reference to DAO 3.0 Changes to DAO 3.5 When File Opened
Q158072 XL97: Menu Added in Wrong Position on Menu Bar
Q158080 XL97: Cannot Paste Array Formula in Its Original Cell
Q158083 XL97: FindPrevious Method Does Not Support Discontiguous Range
Q158222 XL97: ParamArrays are Always Zero-Based
Q158244 XL97: How to Create Application Level Event Handlers
Q158246 XL97: How to Determine if the Active Cell Contains a Comment
Q158353 XL97: Error When Invalid Characters in Drawing Object Name
Q158355 XL97: ParamArray Must be Declared as an Array of Variant
Q158360 XL97: PasteSpecial Method Activates Target Sheet
Q158402 XL97: Using the RefEdit Control with a UserForm
Q158434 XL97: Cannot Make Changes to Some Shortcut Menus
Q158472 XL97: No Automatic Type Coercion Between Variable Types
Q158550 XL97: Problems Disabling and Enabling Shortcut Menus
Q158632 XL97: Limitations for Naming Visual Basic Modules
Q158638 XL97: ApplyNames Method May Cause Invalid Page Fault
Q158639 XL97: Edit Box Does Not Appear in ToolBox
Q158659 XL97: Insert and Delete Method of Characters Class May Fail
Q158687 XL97: Error Referring to a Function That Contains a Breakpoint
Q158688 XL97: Closing UserForm Causes MS Excel to Hang
Q158711 XL97: Cannot Edit Text Box with Unlocked Text
Q158746 XL97: Error When Passing an Array Value Between Macros
Q158749 XL97: No Data Validation Property for UserForm TextBoxes
Q158848 XL97: How Create a Startup Screen with a UserForm
Q158895 XL97: Invalid Page Fault After Closing Last Open Workbook
Q158905 XL97: "Bad DLL Calling Convention" When Running a Macro
Q158997 XL97: Error When Variable Refers to Deleted or Moved Sheet
Q159223 XL97: Macro Recorder Doesn't Record Some Menu Commands
Q159230 XL97: Clicking Microsoft Excel on Taskbar Does not Work
Q159336 XL97: Illegal Operation Using Unload with Enter Event
Q159338 XL97: Imported Toolbox Page Loses Caption and Tip Text
Q159465 XL97: "Module Not Found" Error Opening Workbook
Q159466 XL97: List of ID Numbers for Built-In Command Bar Controls
Q159493 XL97: Macro to Create Data Validation Circles for Printing
Q159537 XL97: Cannot Import/Export UserForms Between VBE and VB4.0
Q159548 XL97: Custom Menu Merges with Custom Toolbar
Q159557 XL97: Using System, User, and File Data Sources
Q159619 XL97: Sample Macros to Control Menus and Submenus
Q159697 XL97: Problems Accessing Microsoft Map Visual Basic Help Files
Q159705 XL97: Macro Examples Using OptionButton Controls on a UserForm
Q159715 XL97: Resetting Toolbox to Default Controls and Layout
Q159729 XL97: "255 Characters in Cell" Error when Copying Worksheet
Q159794 XL97: Cannot Programmatically Close Referenced Workbook
Q159845 XL97: Parentheses Around Object May Dereference the Object
Q159858 XL97: Macro Error Accessing OLEObject on Worksheet
Q159861 XL97: Set Window Caption Changes Caption for Active Window
Q159874 XL97: Indexes for Methods and Collections are Rounded
Q159915 XL97: Deleting Cells with a For Each...Next Loop
Q159922 XL97: Using Quit Method May Cause Illegal Operation
Q159938 XL97: Structure and Windows Arguments of Protect Method
Q159944 XL97: Range.PasteSpecial Changes Selection
Q159947 XL97: Illegal Operation Unhiding a Row with a Macro
Q159949 XL97: Input # Statement Does Not Retain Trailing Spaces
Q159957 XL97: Run-time Error '1004' Accessing Locally Defined Name
Q159966 XL97: Redraw Problem Changing Visibility of Object on Dialog Box
Q159997 XL97: Illegal Operation Closing File When VBE Is Visible
Q160032 XL97: Invalid Page Fault Saving a Workbook or Add-In
Q160131 XL97: Cannot Modify Microsoft Excel 5.0 or 7.0 Add-in
Q160219 XL97: Application.SendKeys Does Not Wait for Key Processing
Q160266 XL97: UserForm ListBox Blank when Run from Binder Section
Q160327 XL97: Defined Names Are Case Sensitive in Microsoft Excel 97
Q160457 XL97: "Exit Design Mode" Deactivates Visual Basic Editor
Q160462 XL97: Auto_Close Macros Run When You Use Application.Quit
Q160473 XL97: How to Create a Template for a Toolbox Control
Q160485 XL97: Cannot Run Macro from Macros Dialog
Q160489 XL97: Menu Editor and Make Add-In Dialog Boxes Cause Error
Q160520 XL97: Error Adding or Deleting a Menu Command in a Macro
Q160523 XL97: Cannot Use Custom Function with Data Validation
Q160544 XL97: Path/File Access Error in Macro Under Windows NT
Q160587 XL97: Run-time Error Evaluating Immediate Window Expression
Q160589 XL97: How to Dynamically Resize a UserForm
Q160600 XL97: ScreenUpdating Causes Problems in MS Internet Explorer
Q160647 XL97: How to Programmatically Create a Reference
Q160956 XL97: Cannot Remove User Name from Default Cell Comment Text
Q161072 XL97: Cannot Use Mouse to Populate RowSource or ListFillRange
Q161214 XL97: How to Programmatically Change the Project Name Property
Q161215 XL97: How to Programmatically Create a Collection
Q161221 XL97: Protect Method Password Is Not Applied to Worksheet
Q161324 XL97: Error Using "Mailto:" with FollowHyperlink Method
Q161326 XL97: How to Verify the Value of a CheckBox on a UserForm
Q161346 XL97: How to Determine Which Items Are Selected in a ListBox
Q161393 XL97: Macro to Open the Most Recently Used File
Q161440 XL97: How to Disable Shortcut Menus
Q161477 XL97: Error Using RemoveItem Method
Q161486 XL97: Macro to Change File Type to *.* in Open Dialog Box
Q161496 XL97: How to Customize a Custom Toolbar Button
Q161509 XL97: Status Bar Text Not Displayed
Q161511 XL97: Using AddItem Method When RowSource Is Data Bound
Q161512 XL97: GetSaveAsFilename Method Returns Extra Character
Q161514 XL97: How to Use a UserForm for Entering Data
Q161517 XL97: Visual Basic Example for Using SpinButton with a Date
Q161518 XL97: How to Populate One ListBox Based On Another ListBox
Q161521 XL97: How to Move Between Custom UserForms with CommandButtons
Q161534 XL97: How to Fill ListBox Control With Multiple Ranges
Q161535 XL97: How to Simulate a Paused Visual Basic Procedure
Q161536 XL97: How to Temporarily Hide a UserForm
Q161537 XL97: Setting the Default CommandButton on a UserForm
Q161598 XL97: How to Add Data to a ComboBox or a ListBox
Q161607 XL97: Macro to Change the Date/Time Format in a Header/Footer
Q161609 XL97: Changes to Microsoft Visual Basic for Applications
Q161625 XL97: Cannot Move Among Unlocked Cells in Scroll Area with TAB
Q161677 XL97: How to Record a Macro Using Relative Cell References
Q161736 XL97: Watch Window Does Not Use Procedure Call Context
Q161761 XL97: Summary of Workbook and Worksheet Application Events
Q161816 XL97: Min Can Exceed Max on ScrollBar or SpinButton Control
Q161836 XL97: Deactivate Event Doesn't Occur After Moving Sheet
Q161858 XL97: How to Trap Events for an Embedded Chart
Q161902 XL97: Macro Created in Form by Web Form Wizard
Q161903 XL97: How to Determine the Key Pressed Along with Mouse Button
Q161926 XL97: How to Place a Checkmark Next to a Menu Item
Q161930 XL97: How to Use the GetOpenFilename Method
Q161959 XL97: Conditional Compilation Code Lost With 5.0/95 Format
Q162259 XL97: Unexpected Results Using the SolverAdd Function
Q162323 XL97: Contents of the Samples.xls Workbook
Q162599 Object Is Not Visible After Using CreateObject Method
Q162633 XL97: Visual Basic Help File Is Available for Microsoft Map
Q162721 XL97: VBA Macro Behavior Is Different from Excel 5.0 or 7.0
Q162814 XL97: Sample Macros to Return the ID for a CommandBar Control
Q162878 XL97: Sample Macros That Customize and Control Shortcut Menus
Q162971 Public Variables Are Not Seen on Modules for Sheet or UserForm
Q163011 XL97: Recorded Macro Contains DrawingObjects Method
Q163103 How to Create a GIF File from a Microsoft Excel Chart
Q163263 XL97: New UsedRange Property Behavior
Q163270 XL97: Additional Controls Dialog Box Disappears
Q163497 XL97: Cannot Stop Macro After Switching to Other Program
Q163542 XL97: Calculation Problems with Arrays in Custom Functions
Q163646 XL97: Some On Events Are Not Displayed in Object Browser
Q163718 XL97: Page Setup Command Does Not Exist in Modules
Q163741 XL97: Cannot Use xlDisplayShapes with DisplayDrawingObjects
Q164021 XL97: Run-Time Error '1004' Using CustomViews Collection
Q164810 XL97: Run-Time Error Using ShowDependents Method
Q164920 XL97: DocErr: vbMsgBoxHelpButton Not Listed in Help
Q165103 XL97: Value Returned by VarType for Omitted Arguments Differs
Q165258 XL97: Pressing ALT+F11 May Not Start the Visual Basic Editor
Q165304 XL97: Modules Inserted Manually Are Not in Modules Collection
Q165436 XL97: Warning Appears When You Use GetObject to Open Workbook
Q165495 XL97: Problems Using TripleState Property for OptionButton
Q165501 XL97: Returning Values from ListBox Displaying Multiple Columns
Q165570 XL97: How to Use the TextColumn Property
Q165632 XL97: How to Remove All Items from a ListBox or ComboBox
Q165644 XL97: TextColumn Property Displays Only the First Column
Q165758 XL97: No Combination List-Edit Control for UserForms
Q165780 XL97: Cannot Record External Data Range Properties
Q165866 XL97: How to Use File DSNs and DSN-less Connections
Q165867 XL97: How to Use EnableEvents to Disable Event Handling
Q165929 XL97: Description of the Value2 Property for the Range Object
Q165935 XL97: How to Display a ComboBox List When UserForm Is Displayed
Q166092 XL97: File Size Increases After Launching Visual Basic Editor
Q166093 XL97: Invalid Page Fault Using DropDown Method with ComboBox
Q166101 The Visible Property Does Not Apply to All CommandBars
Q166141 XL97: Error Running Macro To Modify Cell Comments
Q166143 XL97: Macro Error Using Show Method with AutoShape Selected
Q166146 XL97: No Trappable Events for Dialog Sheets and Macro Sheets
Q166252 XL97: How To Create a Group of Mutually Exclusive ToggleButtons
Q166338 XL97: Export Method Code Example in Help Is Incorrect
Q166341 XL97: Preventing UserForm from Being Dismissed with Close Button
Q166347 XL97: Using the SheetChange Event in Microsoft Excel 97
Q166450 XL97: Macro to Tile Windows Does Not Work with Minimized Window
Q166492 XL97: "Unable to Record" Message When Recording a Macro
Q166755 XL97: WE1183: "Customizing Menu Bars, Menus, and Menu Items"
Q166760 XL97: Syntax Error Running Macro That Inserts WordArt
Q166812 XL97: ActiveX Example with Microsoft Word and Microsoft Outlook
Q166932 XL97: List Box Doesn't Work Correctly When Workbook Is Hidden
Additional query words: 8.00 XL97 Fast tips msears excel8 excel97
Keywords : kbualink97 kbdta
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbinfoLast Reviewed: May 26, 1999