XL97: Excel Articles Available by Fax or E-Mail: VBA

ID: Q162320

The information in this article applies to:

SUMMARY

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.

MORE INFORMATION

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

ORDERING ARTICLES BY E-MAIL OR BY FAX

Ordering an Article by E-Mail

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

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 Machine

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

2. When prompted, select the appropriate number for the product you are
   using (for example, for Microsoft Word, select 2).

3. When prompted, select the version of the product that you are using.

4. From the "FastTips Main Menu," select 1 to place a FastTips catalog

   order.

5. At the "to order items from your catalog" prompt, select 1.

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.

7. When prompted, select the fax option and enter your three-digit area
   code and seven-digit fax number.

8. When you're finished ordering, hang up.

If you have problems receiving a fax, please call the FastTips Hotline at (425) 635-3199.

ARTICLE LISTING

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        : kbinfo

Last Reviewed: May 26, 1999