Visual Basic Archives Page 59

-       Selva V Pasupathy , Hyderabad, India

   580. Programatically find a blank row NYARCH writes: I want to have excel copy an entire row to a new sheet based upon a cell entry. For example I have data in cells A8:AG8, I want to have Excel copy the entire row to sheet “a” if the value in H8 is “ir”, and sheet “b” if the value in H8 is “RR” and not just copied, I need it copied to… Keywords: AutoFilter, Days, VBA, Macro, Web

   581. WordCount Keywords: VBA, Object, Web, Comments, TRIM

   582. Sample Macro to Determine If a Year Is a Leap Year In Microsoft Excel, you can determine whether a date occurs during a leap year by using a Microsoft Visual Basic for Applications… KB#266672. Keywords: VBA, Macro, Web, Window

   583. How to Make Spinner Whose Minimum Value Is Less Than Zero In the products listed at the beginning of this article, the spinner control that is on the Forms toolbar has a minimum value of zero. This article includes a Microsoft Excel Visual Basic for Applications macro example that demonstrates how you… KB#151324. Keywords: Format, VBA, Macro, Object, Toolbar, Web

   584. Link back to original workbook There is a command in VBA called GetOpenFileName. It displays the File Open box. You can naviagate to a directory, select the file and then click Open. At this point, the command does not open the file, it merely passes the name back to your program. Here is an example of the code in… Keywords: Years, Links, Macro, VBA, Files, Hyperlinks, Web

   585. Selecting files within VBA There is a command in VBA called GetOpenFileName. It displays the File Open box. You can naviagate to a directory, select the file and then click Open. At this point, the command does not open the file, it merely passes the name back to your program. Here is an example of the code in… Keywords: Years, Links, Macro, VBA, Files, Hyperlinks, Web

   586. Stopping an Endless Loop There is a command in VBA called GetOpenFileName. It displays the File Open box. You can naviagate to a directory, select the file and then click Open. At this point, the command does not open the file, it merely passes the n ame back to your program. Here is an example of the code in… Keywords: Years, Links, Macro, VBA, Files, Hyperlinks, Web

   587. How to Change Connection Information for a Query After you change the folder location or server name of a database that a query or PivotTable is using in Microsoft Excel, you cannot manually change the connection information to the new folder or serv er. This article offers a programmatic… KB#816562. Keywords: Query, Arrays, PivotTables, VBA, Macro, Web

   588. How to Restore a BuiltIn Menu When you use the Delete method in a Visual Basic for Applications macro to delete a menu from a built-in menu bar, you cannot restore the menu and all of its associated menu items with one macro command. If you want to d elete a menu and then… KB#167382. Keywords: VBA, Macro, Toolbar, Web

   589. How to Remove UserDefined Functions from Function Wizard When you create a custom function in Microsoft Excel using Visual Basic for Applications, it will be displayed in the Function Wizard under the User Defined Function category. You can prevent t he custom function from being displayed in the… KB#142123. Keywords: VBA, Macro, User Defined Function, Web