Microsoft Excel Articles Available by Fax or E-Mail: VBALast reviewed: February 12, 1998Article ID: Q162320 |
The information in this article applies to:
SUMMARYThis 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.
MORE INFORMATIONThe "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 ORDERING ARTICLES BY E-MAIL OR BY FAX
Ordering an Article by E-MailTo 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
For more information about how to order an article by e-mail, send an e-
mail message to the following e-mail address:
mshelp@microsoft.com Ordering an Article over the Phone and Having It Sent to a Fax MachineTo 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:
ARTICLE LISTINGARTICLE 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 in MS Excel 97 Q157202 XL97: Color Palette Looks Different in MS 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 97 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 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 MS Excel 5.0 or 7.0 Q162814 XL97: Returning 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
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |