Home > Excel Help Portal > Programming Excel

<<  (Page 3)  Previous              Next  (Page 5)  >>

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.

151. How to Use Automation to Create Office Command Bars and Controls with Visual Basic .NET This article demonstrates how to automate Excel to create a command bar that contains buttons, drop-down list boxes, combo boxes, and pop-up... KB#303017. Keywords: Download, OLE, Styles, Errors, Class, Combo Box, VBA, Object, Templates, Web, Window

 
152. Sample Macros to Create a Module from an Existing Module, Named Range, or Text File You may want to programmatically insert stored Visual Basic for Applications (VBA) code into a new workbook that you create with the Workbooks.Add method. This may be necessary if you programmatically create new workbooks that you want to contain... KB#245801. Keywords: Export, VBA, Macro, Object, VBE, File Name, Text Files, Web, Window

 
153. Navigating within a Sheet and Around a Workbook You would use the RtArrow key though you could change the direction of the Enter key from Down to Right. Use of the TAB key as mentioned before would take you to A1 if you attempt to go outside the used range. Navigation to Another Sheet (#anothersheet) Some VBA Code Sheets("My Sheet").Select... Keywords: Borders, Colors, Formulas, VBA, Macro, Toolbar, Hyperlinks, Web, Comments, Validation

 
154. How to Use System, User, and File Data Sources Microsoft Office contains Open Database Connectivity (ODBC) drivers that you can use to access data from other programs. This article describes the different types of data source names (DSN) that you can install and use in Microsoft Office... KB#213772. Keywords: Query, Microsoft Access, SQL, VBA, Macro, File Name, Files, Registry, Text Files, Web

 
155. How to Show a "Now Processing" Dialog While Macro Runs This article describes how you can display a dialog box while a macro is running in the background. The purpose of displaying a dialog box is to alert the user that the application is busy while your macro is... KB#162257. Keywords: Export, VBA, Macro, UserForm, Window

 
156. How to get Windows Status Information from Windows API in Excel 2000 In Microsoft Excel you can programmatically obtain system status information and display it in a worksheet. This step-by-step article provides a sample Microsoft Visual Basic for Applications Sub procedure that displays the following information... KB#213267. Keywords: API, Format, VBA, Macro, Web

 
157. ADO Inserts Data into Wrong Columns in Excel When you use ADO to insert new rows of data into a Microsoft Excel worksheet, if the data includes fields that contain empty string values, ADO may insert the data values of subsequent numeric fields into the wrong columns in Excel. This... KB#314763. Keywords: Query, ActiveX, Export, OLE, SQL, Errors, VBA, Object, Error Message, DB

 
158. 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#141288. Keywords: Errors, Formulas, VBA, Web, Window

 
159. GetObject and CreateObject Behavior of Office Automation Servers This article discusses the different behaviors that occur when you use the GetObject and CreateObject functions with various versions of Microsoft Office applications. GetObject and CreateObject are functions that are provided by Microsoft... KB#288902. Keywords: ActiveX, API, OLE, Errors, Class, Object, VBA, Web, Window

 
160. Macro to Sort Data in Multiple Columns as One Column Microsoft Excel does not have a built-in method to sort a newspaper (snaking) column of data. This article contains a sample macro to sort data that is in a newspaper column... KB#247311. Keywords: SERIES, Sorting, Format, Styles, VBA, Macro, Web

 
161. Macro to Search for Cell Formats: Font, Border, and Interior In Microsoft Excel, there is no built-in feature to allow you to search on the characteristics of a cell. However, you can create a Microsoft Visual Basic for Applications procedure that allows you to search this... KB#213622. Keywords: Borders, Colors, ColorIndex, Fonts, Format, Outline, Patterns, Styles, VBA, Macro, Object, Toolbar, Web

 
162. About This Site Thanks for your interest in my web site. I began putting this site together in January of 1998, mostly as a way to learn Microsoft's FrontPage program. I had no idea that it would become so large, or generate so much interest. In June of 1998, I added a hit counter to the main page. Since then,... Keywords: Add-In, Sorting, Format, Formulas, Links, VBA, Templates, Web

 
163. Using the LoadPicture Function with an Image Control In Microsoft Excel 2000, you can add an image control to a user form. There are two ways to specify which picture file is displayed in the image control; you can specify the picture when you design the user form, or you can specify the picture... KB#213732. Keywords: VBA, Macro, UserForm, File Name, Files, Web

 
164. How to Save Files in Other Formats This article explains how to save files in different formats, and provides additional information to be aware of when saving... KB#166173. Keywords: Add-In, Charts, Format, Class, Macro, VBA, Files, Save A File, Templates, Toolbar, Text Files

 
165. How to Use the Query Before and AfterRefresh Events In Microsoft Excel, you can automatically run a macro before or after updating (refreshing) worksheet query data. You can do this with the BeforeRefresh and AfterRefresh Visual Basic for Applications events. This article contains an example of how... KB#182735. Keywords: Query, Class, VBA, Macro, Setup, Files, Setup Program, Toolbar, Web, Window

 
166. How to use the Estimates Sample When the Database and the Web Server Are on Different Computers The Estimates sample that is included with Microsoft Visual Studio Tools for the Microsoft Office System describes how to use managed code extensions and how those managed code extensions can work together with Microsoft SQL Server databases and... KB#824006. Keywords: SQL, Class, VBA, Setup, Files, Templates, Web, Window

 
167. How to Obtain the Window Handle for an Office Automation Server This article demonstrates how to obtain the window handle of an Microsoft Office application while automating that application from Visual... KB#258511. Keywords: API, Microsoft Access, Class, VBA, Object, Window

 
168. How to Run Sample Code from Knowledge Base Articles The Microsoft Knowledge Base contains a number of articles that include sample code for Visual Basic for Applications macros. Many of these macros illustrate basic concepts of programming in Visual Basic for the various Office 2000 applications.... KB#212536. Keywords: VBA, Macro, Templates, Internet Explorer, Web, Comments, Window

 
169. How to Find Visual Basic for Applications Help This article describes where to find helpful resources to use when you are programming in Microsoft Excel using Microsoft Visual Basic for... KB#142128. Keywords: Object, VBA, Files, Hyperlinks, Web, Window

 
170. Supercharge your formulas 95% of Excel users do not know about CSE Formulas. When most people hear their real name, they think "That doesn't sound the least bit useful" and never bother to learn about them. If you think SumIf and CountIf are cool, you will soon discover that Ctrl+Shift+Enter (CSE) formulas will run circles... Keywords: Conditional Sum, Arrays, Errors, Formulas, Sounds, VBA, Files, Web, AVERAGE

 
171. How to Convert a Numeric Value into English Words This article contains sample Microsoft Visual Basic for Applications functions that you can use to convert a numeric value into its equivalent in English words. For example, you can change 32.50 into Thirty Two Dollars and Fifty Cents by... KB#140704. Keywords: Formulas, VBA, Macro, Web

 
172. How to Use Input Boxes with Visual Basic for Applications In Microsoft Excel, you can create a Microsoft Visual Basic for Applications procedure that uses an input box to gather data from a user. To create an input box, you can use the InputBox method or the InputBox function. The main difference between... KB#213614. Keywords: SERIES, Errors, VBA, Macro, Object, Error Message, Web

 
173. How to Run Sample Code from Knowledge Base Articles The Microsoft Knowledge Base contains a number of articles that contain sample code for Visual Basic for Applications macros. Many of these macros illustrate basic concepts of programming in Visual Basic for Microsoft Office. This article... KB#173707. Keywords: VBA, Macro, Templates, Internet Explorer, Web, Comments, Window

 
174. Excel -- Comments -- Programming Programming You can add any of the following macros to a workbook that opens automatically when Excel opens (e.g. Personal.xls), then add a toolbar button or shortcut key to run it. Change the User Name Insert a Plain Comment Insert a Formatted Comment Reset Comments to Original Position Resize... Keywords: Arrays, Errors, VBA, Macro, Object, Toolbar, Comments

 
175. How to Run Sample Code from Knowledge Base Articles The Microsoft Knowledge Base contains a number of articles that include sample code for Visual Basic for Applications macros. Many of these macros illustrate basic concepts of programming in Visual Basic for the various Office XP programs.... KB#290140. Keywords: VBA, Macro, Templates, Internet Explorer, Web, Comments, Window

 
176. How to Delete Cells with a For Each...Next Loop Next loop in a different way from versions of Microsoft Excel earlier than Excel 97. This article describes the differences and provides a Visual Basic for Applications macro example... KB#213544. Keywords: VBA, Macro, Web

 
177. How to Delete Cells with a For Each...Next Loop Next loop in a different way from versions of Microsoft Excel earlier than Excel 97. This article describes the differences and provides a Visual Basic for Applications macro example... KB#291300. Keywords: VBA, Macro, Web

 
178. How To Retrieve the Results of a Parameter Query Using DAO In the versions of Microsoft Excel listed at the beginning of this article, you can use data access objects (DAO) in Microsoft Visual Basic for Applications to retrieve the results of a Parameter QueryDef from Microsoft Access. This... KB#146607. Keywords: Criteria, Query, Years, DAO, Microsoft Access, Sales, Fonts, VBA, Macro, Object, Toolbar, Web

 
179. How to Convert a Numeric Value into English Words This article contains sample Microsoft Visual Basic for Applications functions that you can use to convert a numeric value in a Microsoft Excel worksheet cell into its equivalent in English... KB#213360. Keywords: Formulas, VBA, Toolbar, Web

 
180. VBA Fundamentals Tutorial Return on Investment and Return on Equity Business Model Workbook model of key inputs to the ROI and ROE measures including profit margin, asset turnover and equity multiplier. Du Pont style analysis of performance using goal seek and multiple scenarios. Highlighting and Exporting Cell Notes You... Keywords: Criteria, ROE, ROI, Colors, Fonts, Format, Styles, Errors, Formulas, Printing, Command Button, Macro, Object, OnEntry, VBA, Error Message, Goal Seek, Scenarios, Comments, Validation

 
181. Templates, book.xlt, sheet.xlt, and beyond Keywords: Years, Download, Borders, Colors, Format, Gridlines, Patterns, Styles, Startup, Printing, Class, VBA, Files, Templates, Toolbar, Web, Comments, IS

 
182. How to Delete, Restore, and Edit Menu Items Manually Microsoft Excel 97 uses a different method to edit, delete and restore menus and menu items than earlier versions of Microsoft Excel. This article explains the difference between a toolbar, a menu bar and a command bar in Microsoft Excel 97. It... KB#157769. Keywords: Format, Macro, VBA, Toolbar

 
183. How to Use the GetOpenFilename Method This article provide instructions and examples on using the GetOpenFilename method in a Visual Basic for Applications... KB#161930. Keywords: Add-In, Query, Wildcard, Errors, VBA, Macro, File Name, Files, Text Files, Web

 
184. How to Delete Cells with a For Each...Next Loop Next loop in a different way from earlier versions of Microsoft Excel. This article describes the differences and provides a Visual Basic for Applications macro example that illustrates how to... KB#159915. Keywords: VBA, Macro, Web

 
185. Excel 2002 PostService Pack 2 Hotfix Package: July 11, 2003 This article describes the Microsoft Excel 2002 issues that are fixed in the Microsoft Excel 2002 Post-Service Pack 2 Hotfix package that is dated July 11, 2003. Issues That Are Fixed in the Hotfix Package The following issues are fixed in this... KB#823338. Keywords: Dates, DDE, Arrays, Formulas, Links, VBA, File Name, Files, Registry, Web

 
186. How to Use the Query BeforeRefresh and AfterRefresh Events In Microsoft Excel, you can automatically run a macro before or after updating (refreshing) worksheet query data. You can do this with the Visual Basic for Applications BeforeRefresh and AfterRefresh events. This article contains an example of how... KB#213187. Keywords: Query, Class, VBA, Macro, Setup, Files, Setup Program, Web, Window

 
187. How to Copy One of Each Record Type to Another Worksheet Using Microsoft Visual Basic for Applications in Microsoft Excel, you can copy a single instance of a record type to another... KB#151344. Keywords: Clipboard, VBA, Macro, Toolbar, Web

 
188. Creating charts with time as X-axis Roy asks this week's question. I have a small problem regarding the x-axis on charts. The data that I have needs to be plotted against time down to the minute. The data points are randomly spaced, so there is not an equivalent amount of time between each data point. When Excel creates my chart, it... Keywords: Charts, SERIES, Time Series, Dates, Days, Sales, Format, VBA, Web

 
189. Error Free VBA Now that you've had a good laugh at the title of this page ("Error Free VBA"), I'll point out that although you cannot make your VBA code error-free, you can at least try to make it error-resistant. In my Quick Chart VBA page and other pages on this site, I've presented some VBA procedures to help... Keywords: Charts, SERIES, Format, Outline, Errors, VBA, Macro, Object, UserForm

 
190. How to Dynamically Add and Run a VBA Macro from Visual Basic When Automating an Office product from Visual Basic, it may be useful to move part of the code into a Microsoft Visual Basic for Applications module that can run inside the process space of the server. This can boost overall execution speed for... KB#219905. Keywords: VBA, Macro, Object, VBE, Text Files

 
191. How to Force Macro Code to Wait for Outside Procedure In the versions of Microsoft Excel listed at the beginning of this article, you can use a Visual Basic for Applications macro to run other Windows and MS-DOS applications and procedures. The macro code in Microsoft Excel continues to execute... KB#147392. Keywords: Errors, VBA, Macro, Files, Text Files, Web

 
192. How To Add the Workbook Path to the Title Bar This article provides a sample Microsoft Visual Basic for Applications macro that adds the workbook path and file name to the title bar of a workbook when opening or saving a... KB#272717. Keywords: VBA, Macro, File Name, Save A File, Toolbar, Web, Window

 
193. How to Get Prime Numbers or Factors A prime number is any integer that can be divided evenly only by itself and one. A factor of a number is an integer that can be evenly divided into that number. This article contains Microsoft Visual Basic for Applications macros for Excel that... KB#202782. Keywords: VBA, Macro, Web

 
194. Easy instructions to create a user form Excel 97 introduced new User Forms. In English, teach me how to create and use a list box. Mr. Excel recently completed a custom application for one of our readers. In this Excel App, the user would enter 150 data points for a specific part number on sheet 1. At the click of a button, this part... Keywords: Text Box, Errors, Combo Box, VBA, Macro, UserForm, Web, Window

 
195. Sample Macros for Customizing Menus and Submenus In Microsoft Excel 2000, toolbars, menu bars, and shortcut menus are considered a single type of object, called a command bar. This behavior is different from versions of Excel earlier than Excel 97. Although most Visual Basic for Applications... KB#213550. Keywords: Format, VBA, Macro, Object, Menu Command, Toolbar, Web

 
196. How to Use a Visual Basic Macro to Sort Arrays in Excel In Microsoft Excel 2000, there is no direct method for sorting an array of values with a Microsoft Visual Basic for Applications macro or procedure. This article discusses two different algorithms that you can use to sort arrays: the Selection... KB#213818. Keywords: Sorting, Arrays, VBA, Macro, Web

 
197. How to Concatenate DDE to MSQuery Statements In Microsoft Query, to use concatenated variables, and to know where and how to break a line of code for Line Continuation, you need to know how dynamic data exchange (DDE) to Microsoft Query statements are formatted. This article provides... KB#149248. Keywords: Query, DDE, Format, Styles, VBA, Web

 
198. How to Use the ApplyCustomType Method to Format Charts When you run a Microsoft Visual Basic for Applications macro in Microsoft Excel 2000, you can use the ApplyCustomType method to apply standard or custom chart types to a chart or a series in a chart. This article explains how to use... KB#213521. Keywords: Charts, SERIES, Format, Errors, VBA, Macro, Object, Error Message, Web

 
199. How to Copy One of Each Record Type to Another Worksheet Using Microsoft Visual Basic for Applications In Microsoft Excel 2000, you can use Microsoft Visual Basic to copy a single instance of a record type to another... KB#213292. Keywords: Clipboard, VBA, Macro, Web

 
200. How to Use the RefEdit Control with a UserForm This article describes the RefEdit control and provides information about how to use it in a... KB#213776. Keywords: ActiveX, DLL, Patterns, Formulas, Command Button, VBA, Object, UserForm, File Name, Toolbar, Web, Window

 

<< (Page 3)  Previous              Next  (Page 5) >>