Visual Basic Archives Page 62

-       Selva V Pasupathy , Hyderabad, India

   610. Macro to Link a Range of Cells in Word This article provides an example of how to link a Microsoft Excel worksheet to a Microsoft Word document using a Microsoft Visual Basic for Applications macro in conjunction with OLE Automation… KB#213316. Key words: OLE, VBA, Macro, Object, Links, Web

   611. Embedded Excel Worksheets Shrink When You Edit Them In Microsoft PowerPoint, when you edit an embedded Microsoft Excel worksheet, the worksheet object resizes… KB#300523. Keywords: Object, Registry

   612. Data Validation The answer to this problem is using Data Validation. This feature, introduced in Excel 97 offers a simple way to have a drop down list right in the cell. There is no problem with moving or resizing.This is a great feature to know. I a m embarrassed that after 50+ tips of the week, I have never fully… Keywords: ActiveX, Errors, Links, Defined Name, VBA, Web, Validation, Window

   613. How to Create a Macro That Counts Text Notes (Cell Notes) In Microsoft Excel, you can use a text note when you do not want to display comments on your worksheet or when you want to print comments on a separate sheet. The More Information section of t his article contains sample Microsoft Visual Basic… KB#141564. Keywords: Printing, VBA, Macro, Web, Comments

   614. Preventing UserForm from Being Dismissed with Close Button When you create a UserForm , a Close button is added to the upper-right corner of the UserForm window. To prevent a user from closing the UserForm with the Close button, use the QueryClose ev ent of the UserForm… KB#213713. Keywords: Command Button, VBA, UserForm, Web, Window

   615. Calculating Depreciation with the Production Method Microsoft Excel includes functions to calculate straight line (SLN), sum of the years digits (SYD), and double-declining balance (DDB) depreciation. A fourth depreciation method, the production meth od, is widely used in business to… KB#213497. Keywords: Years, Formulas, VBA, Macro, Web

   616. How to Populate One List Box Based on Another List Box This article contains an example of using the selected item in one list box control on a UserForm to determine the list that will populate a second list box… KB#213748. Keywords: VBA, UserForm, Web, Window

   617. Excel — Data Entry — Convert Text to Numbers Convert Text to Numbers Convert with Paste Special Convert Dates with Replace All Convert with Text to Columns Convert Trailing Minus Signs Convert Trailing Minus Signs Programmatically Paste as CSV Conv ert Programmatically If you copy data from another program, such as Microsoft Access, or from a… Keywords: Dates, Errors, VBA, Macro, Toolbar

   618. How to Automatically Set Min and Max Scale for YAxis In Microsoft Excel, you can set the Minimum and Maximum properties of the y-axis scale to any value. The example in this article shows the steps necessary to create a Microsoft Visual Basic for App lications procedure that determines the minimum… KB#213644. Keywords: Charts, SERIES, Arrays, VBA, Macro, Web

   619. Macro to Restore Tab Split Box to Default Position In Microsoft Excel 2000, it is possible to adjust the space allocated for displaying sheet tabs and the horizontal scroll bar by moving the tab split box. The tab split box is located between the she et tabs and the horizontal scroll bar. This… KB#213505. Keywords: VBA, Macro, Web, Window