Home > Excel Help Portal > Programming Excel

<<  (Page 7)  Previous              Next  (Page 9)  >>

Programming Excel

The ExcelUser portal offers links to help pages created by top
Excel web sites. This section discusses ways to program
Microsoft Excel using VBA.

351. How to Create an Addin File in Microsoft Excel 97 In Microsoft Excel 97, the process you use to create an add-in file is different than the process for earlier versions of Microsoft Excel. This article contains detailed information about how to create an add-in (.xla) file in Microsoft Excel... KB#156942. Keywords: Add-In, Charts, Password, Macro, VBA, File Name, Comments, Window

 
352. File Is Damaged After It Is Cleaned by Antivirus Software When you try to open, close, or save a workbook, you may receive the following error message: This program has performed an illegal operation and will be shut down. If the problem persists, contact the program vendor. When you click Details,... KB#179373. Keywords: Errors, VBA, Macro, Corrupted, Error Message, Files, Web

 
353. Convert Numbers into Words In all fairness, I stole this from Microsoft. I get a request for this virtually every week. Or get a text file with all the custom functions ready to paste right in. With the custom functions, SpellNumber, GetHundreds, GetTens, and GetDigit, you can convert a numeric value into its equivalent in... Keywords: Formulas, VBA, Macro, Text Files

 
354. How to Paste New Excel Data into an Existing Graph This article provides sample Visual Basic for Applications (VBA) code that takes a range of cells from a Microsoft Excel 2000 worksheet and pastes the data into a Microsoft Graph 2000 object inside another Microsoft Office 2000 program (in this... KB#267974. Keywords: Charts, SERIES, OLE, Format, Links, VBA, Object, Web

 
355. How to Use ADO to Return Data to a ListBox or ComboBox In Microsoft Excel, you can use the ActiveX Data Objects (ADO) library in a Visual Basic for Applications macro to work with a SQL database. This article contains a sample macro that returns the results of your query to a ComboBox control or a... KB#244761. Keywords: Query, ActiveX, SQL, Combo Box, VBA, Macro, Object, UserForm, Web

 
356. How to Fill ListBox Control with Multiple Ranges This article contains an example that fills the list of a ListBox control on a UserForm with data from multiple cell... KB#161534. Keywords: Arrays, VBA, Macro, UserForm, Web, Window

 
357. How to Mark an Automation AddIn Function as Volatile This article contains sample Microsoft Visual Basic for Applications code that demonstrates how to mark an Excel Automation Add-In function as... KB#278328. Keywords: Add-In, ActiveX, DLL, Class, VBA, Object, Web

 
358. Using VBA Code to Make a Spinner Display Noninteger Values A spinner control only uses integer values. This article shows how to use Microsoft Visual Basic for Applications code to make a spinner control display noninteger values in an edit... KB#151498. Keywords: Format, VBA, Macro, Object, Toolbar, Web

 
359. How to Remove Individual AutoFilter DropDown Lists In Microsoft Excel 97, you can programmatically hide an AutoFilter drop-down list for a specific field in a list by using a new argument for the AutoFilter method in Microsoft Visual Basic for Applications. This article includes an example... KB#162049. Keywords: AutoFilter, Criteria, VBA, Macro, Object, Toolbar, Web

 
360. Defined Names Are Case Sensitive When you run a Visual Basic for Applications macro in Microsoft Excel, and your macro code reads the Name property of an item in the Names collection, the result may be slightly different than the result you receive in versions of Excel earlier... KB#213533. Keywords: Arrays, Defined Name, VBA, Macro, Web

 
361. How to Programmatically Create a Reference This article provides sample Microsoft Visual Basic for Applications Sub procedures (or macros) that programmatically create and remove a reference to another... KB#213529. Keywords: Class, VBA, Macro, Object, VBE, Web, Window

 
362. Lots 'o Little Code I have been adding a lot of whole programs so I thought this was a good time to drop back to basics and show how I do some little stuff. This is a start, more to come shortly. So you have a password on some cells. You need to sort or something in your code but your users should not be able to move... Keywords: Sorting, Colors, Arrays, Errors, Formulas, Password, VBA, Macro, File Name, Scenarios, AVERAGE, INDIRECT

 
363. How to Reduce the Chances of Macro Virus Infection This article explains how you can reduce the risk of infecting Microsoft Excel -- including your worksheets, templates, and add-ins -- with macro... KB#269613. Keywords: Third-Party, Password, Macro, VBA

 
364. Cannot Open Workbook That Contains XLM Macros When Macro Security Is Set to High When you try to open a workbook, you receive the following error message: This workbook cannot be opened under High Security Level because it contains a type of macro (Microsoft Excel 4.0 macro) that cannot be disabled or signed. To open... KB#820739. Keywords: Errors, Macro, VBA, Registry

 
365. Cannot Insert File Using Named Range of Excel File When you attempt to insert a named range from a Microsoft Excel file, you receive the following error message: The document name or path is not valid. Try these suggestions. * Check the file permissions for the document or drive. * Use the File... KB#224699. Keywords: Errors, VBA, Macro, Files, Toolbar, Web

 
366. Visual Basic Example Using If and Case Statements Then...Else statement or a Select Case statement. The If...Then...Else statement executes a group of statements based on... KB#141691. Keywords: VBA, Macro, Web

 
367. How to Use the Registry to Override the Default Behavior When Excel Tries to Recover Data Excel 2003 contains a feature that allows you to recover data from corrupted workbooks. This article describes how to use the registry to override the default behavior when Excel tries to recover... KB#826836. Keywords: Formulas, Object, VBA, Corrupted, Registry

 
368. How to Convert All Files on a Server to Microsoft Excel The Microsoft Excel 97 File Conversion add-in converts all of the files in one folder. This article describes how to use a Visual Basic for Applications macro to convert the files in a folder and all of its... KB#170431. Keywords: Add-In, Format, VBA, Macro, Object, Files, Toolbar, Web

 
369. Visual Basic Macro to List Circular References In a Microsoft Excel 2000 worksheet, when a formula in a cell refers to the same cell the formula occupies, either directly or indirectly, a circular reference is created. In Excel 2000, tracing tools are provided on the Auditing toolbar to help... KB#213826. Keywords: Errors, Formulas, VBA, Macro, Circular References, Toolbar, Web, Auditing

 
370. Pointer Is an Hourglass When You Display a Message Box When you run a Visual Basic for Applications macro in Microsoft Excel 97, if the macro uses the MsgBox function to display a message box on the screen, the pointer may appear as an hourglass or as the arrow pointer. When you dismiss the message... KB#159964. Keywords: VBA, Macro, Toolbar, Web, Window

 
371. How To Create a Group of Mutually Exclusive ToggleButtons This article provides an example of how to create a group of mutually exclusive ToggleButton controls on a... KB#166252. Keywords: VBA, UserForm, Toolbar, Web, Window

 
372. Workbooks Containing User Forms Take Excessively Long Time to Save Across WAN Connections When you save Excel workbooks that contain user forms, it typically takes about one minute to save to the local computer or within the local area network (LAN). When you save the same workbooks over a wide area network (WAN), it can take an... KB#254733. Keywords: VBA, Object, Web, Window

 
373. How to Use a Custom Function in Another Workbook In Microsoft Excel, you can create custom Microsoft Visual Basic for Applications functions to perform calculations. By default, these custom functions are available to all worksheets in the workbook that contains the custom function. Therefore,... KB#213645. Keywords: Errors, Formulas, VBA, Web, Window

 
374. No Menu Command to Select All Hyperlinks Within a Worksheet Microsoft Excel 2000 has no menu command that lets you select all hyperlinks within a... KB#213790. Keywords: SERIES, Links, VBA, Macro, Object, Menu Command, Hyperlinks, Web

 
375. How to Reference a Cell in the Header or Footer This article contains a sample Microsoft Visual Basic for Applications macro that references a cell to the header or footer of a... KB#273028. Keywords: Printing, VBA, Macro, Object, Setup, Web, Window

 
376. How to Programmatically Subtract or Sum Two Ranges of Data In Microsoft Excel 2000, you can use a Microsoft Visual Basic for Applications macro to programmatically subtract or sum two ranges of data. You can do this in the same workbook, or from more than one workbook, using defined... KB#213337. Keywords: VBA, Macro, Object, Web

 
377. How to Obtain the SQL Statement for a PivotTable When you are working with a Microsoft Excel PivotTable, you may want to determine its data source. To do this, use the SourceData property in Microsoft Visual Basic for Applications... KB#131331. Keywords: Criteria, Query, SQL, Arrays, PivotTables, VBA, Macro, Object, Web

 
378. How to Convert All Files on a Server to Microsoft Excel The Microsoft Excel File Conversion add-in converts all of the files in one folder. This article describes how to use a Visual Basic for Applications macro to convert the files in a folder and all of its... KB#213699. Keywords: Add-In, Format, VBA, Macro, Object, Files, Web

 
379. How to Place a Check Mark Next to a Custom Menu Item When you create custom menus, you may want to add a check mark next to a particular menu item to show that the item is selected. For example, when you point to Filter on the Data menu and then click AutoFilter , a check mark is placed next... KB#213735. Keywords: AutoFilter, VBA, Macro, Object, Toolbar, Web

 
380. How to Automate Smart Tags by Using Visual Basic for Applications In Microsoft Excel, you can use smart tags to quickly take actions on data entered in a workbook. This article contains sample Microsoft Visual Basic for Applications (VBA) code that demonstrates how to automate smart... KB#293808. Keywords: VBA, Smart Tag, Web

 
381. Import a file daily into current workbook Judith posed this week's question. I need to import a file daily. I'd like to add the file each day to an existing workbook and have the worksheet named for the d/m/y. A short visual basic macro will make this a simple task. One problem - the tab name of a sheet can not include a slash. So, the... Keywords: VBA, Macro, File Name, Toolbar, Web

 
382. How to set a Print Area by Using a Defined Name in Excel 2000 In Microsoft Excel, if you have a macro that prints a range of cells on your worksheet, it may not print all of your data if you insert rows in that range. However, you can create a print macro that automatically adjusts when you insert rows. To... KB#213648. Keywords: Defined Name, Printing, VBA, Macro, Setup, Web, Window

 
383. How to Simulate a Paused Visual Basic Procedure There is no built-in method for pausing a macro in Microsoft Excel. This article contains one method for stopping a macro for user input and then continuing when the user clicks a... KB#161535. Keywords: Borders, Format, Outline, Styles, VBA, Macro, Object, Toolbar, Web, Window

 
384. How to Programmatically Delete Defined Names with Links This article shows you how to create a Microsoft Visual Basic for Applications Sub procedure (macro) that displays all the defined names in the active workbook that have an external reference to a defined name in a different workbook. With the... KB#213385. Keywords: Errors, Links, Defined Name, VBA, Macro, Object, Web

 
385. How to Verify the Value of a CheckBox on a UserForm In Microsoft Excel, a CheckBox control on a UserForm can have one of three values: True , False , or Null . This article contains a sample macro that programmatically retrieves the value of a CheckBox... KB#213760. Keywords: VBA, Macro, UserForm, Web, Window

 
386. Making HTML web pages from Excel worksheets Excel contains a command to save an area of a worksheet in HTML format so that it can viewed through a web browser and incorporated in a website. The files created by this command are excessively large and contain limited formatting. Alternatively a macro can be used to create a web page which... Keywords: SERIES, SQL, XML, Borders, Colors, Fonts, Format, Styles, Arrays, Macro, VBA, Files, Text Files, HTML, Hyperlinks, Web

 
387. How to Programmatically Increment a Date With a Spinner In Microsoft Excel, you can use a spinner control to change values on a worksheet or in a Microsoft Visual Basic for Applications procedure. To use the spinner to increment and decrement a value over a wide range, you must set and use the spinner... KB#213464. Keywords: VBA, Macro, Web

 
388. How to Programmatically Create a Chart Without Selecting a Range of Cells When you record a macro to create a chart (on the Tools menu, point to Macro , and then click Record New Macro ), the range of cells used to create the chart is fixed by Microsoft Excel. This article contains a sample Microsoft Visual Basic... KB#213352. Keywords: Charts, VBA, Macro, Web

 
389. How to Determine If a File Is ReadOnly This article describes how to programmatically determine whether a Microsoft Excel file has an attribute of read-only, and how to determine whether a file is opened as... KB#213266. Keywords: VBA, Macro, File Name, Web

 
390. How to Create a Group of Mutually Exclusive ToggleButton Controls This article provides an example of how to create a group of mutually exclusive ToggleButton controls on a... KB#213714. Keywords: VBA, UserForm, Web, Window

 
391. DDE Clients Cannot Use a RUN Command to Run an Inline Macro After a Security Update Client applications can use Dynamic Data Exchange (DDE) to issue a macro RUN command to Excel 2002. This command may stop working after you update to Service Pack 3 or the Security Update that is listed below. To the client application, the... KB#821137. Keywords: DDE, Errors, Macro, VBA, Window

 
392. How to Add the Workbook Path to the Footer This article contains a sample Microsoft Visual Basic for Applications macro ( Sub procedure) that adds the workbook path and file name to the footer of a... KB#213615. Keywords: Printing, VBA, Macro, Object, Setup, File Name, Web, Window

 
393. How to Hide Sheets and Use xlVeryHidden Constant in a Macro In Microsoft Excel, you can hide sheets in a workbook so that a user cannot see them. You can hide any sheet type in a workbook, but you must always leave at least one sheet... KB#142530. Keywords: Format, VBA, Macro, Object, Templates, Web

 
394. Cannot Open Workbook That Contains XLM Macros When Macro Security Is Set to High When you attempt to open your file, you receive the following error message: This workbook contains a type of macro (Microsoft Excel version 4.0 macro) that cannot be disabled or signed. Therefore, this workbook cannot be opened under High... KB#291206. Keywords: Errors, Macro, VBA, Registry

 
395. How to Use DAO in Excel Without Referencing DAO Library In Microsoft Excel, if you attempt to use data access objects (DAO) without first referencing the Microsoft DAO 3.0 or 3.5 Object Library, you may receive an error message. This can cause difficulties when you are developing applications... KB#152400. Keywords: DAO, OLE, Errors, VBA, Object, Error Message, Toolbar, Web

 
396. Cannot Open Workbook That Contains XLM Macros When Macro Security Is Set to High When you attempt to open your file, you receive the following error message: This workbook contains a type of macro (Microsoft Excel version 4.0 macro) that cannot be disabled or signed. Therefore, this workbook cannot be opened under High... KB#230889. Keywords: Errors, Macro, VBA, Registry

 
397. Sample Code to Change Source of Linked Excel Worksheet This article provides a sample Microsoft Visual Basic for Applications macro (Sub procedure) that searches a presentation for linked Excel OLE objects and changes the linked source of these objects to a single source workbook that you specify.... KB#222708. Keywords: Charts, OLE, Links, VBA, Macro, Object, Web

 
398. How to Verify the Value of a CheckBox on a UserForm In Microsoft Excel, a CheckBox control on a UserForm can have one of three values: True, False or Null. This article contains a sample macro that programmatically retrieves the value of a CheckBox... KB#161326. Keywords: VBA, Macro, UserForm, Web, Window

 
399. How to Programmatically Reset a Workbook to Default Styles The following Microsoft Visual Basic for Applications Sub procedure removes all styles in a Microsoft Excel workbook and then adds back the default styles you see in a new workbook. This macro may be helpful for removing extra styles added to... KB#247980. Keywords: Download, Format, Styles, Startup, VBA, Macro, Corrupted, Files, Templates, Web

 
400. How to Compare Data in Two Columns for Duplicates This article describes two methods for comparing two columns of data to find duplicate entries between the two... KB#139882. Keywords: Errors, Formulas, VBA, Macro, Web

 

<< (Page 7)  Previous              Next  (Page 9) >>