Visual Basic Archives Page 58

-       Selva V Pasupathy , Hyderabad, India

   570. How to Programmatically Hide and Unhide the Windows Taskbar Advanced: Requires expert coding, interoperability, and multiuser skills. By using API calls in Visual Basic for Applications, you can programmatically hide the Microsoft Windows 98 or Micro soft Windows NT 4.0 taskbar. This article shows you how… KB#290150. Keywords: API, VBA, Web

   571. How to perform a callback into an assembly from a worksheet function Certain functionality in the Microsoft Excel object model and in the Microsoft Word object model is tightly integrated with Microsoft Visual Basic for Applications and is not access ible with COM interop. You must use a Visual Basic for… KB#830467. Keywords: Class, VBA, Object

   572. How to Create Yes and No Buttons for a Custom Message Box By default, the MsgBox function in a Microsoft Visual Basic for Applications procedure contains a single OK button. However, you can display other buttons in the message box. This article prov ides a sample Visual Basic macro that displays a… KB#213613. Keywords: VBA, Macro, Toolbar, Web

   573. Changing an Integer to an Excel Serial Number Many programs export dates as integers. This article contains a sample Microsoft Visual Basic for Applications macro ( Sub procedure) that transforms an integer date into a Microsoft Excel serial… KB#21 3446. Keywords: Dates, Export, Format, VBA, Macro, Web

   574. Printing using macros Expanding the possibilites with Macros This page contains some VBA macros. If you need assistance to install or to use a macro please refer refer to my GetFormula… Keywords: Errors, Formulas, Printing, VBA, Macro, Setup, Web, Comments, Window

   575. Automation Example with Microsoft Word and Microsoft Outlook It is possible to create a Visual Basic for Applications macro that uses data from a Microsoft Word document and a Microsoft Excel workbook to send messages from Microsoft Outlook. This art icle contains an example of one way that you can do… KB#213712. Keywords: VBA, Macro, Object, Web

   576. How to Play Sounds Using Visual Basic for Applications In Microsoft Excel 97, cell notes have been replaced with cell comments and no longer support sound notes. However, you can use a Visual Basic for Applications procedure to play sounds. In order to play a sound in a Visual Basic for… KB#158140. Keywords: API, Sounds, VBA, Macro, Web, Comments

   577. 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 type of sheet in a workbook, but you must always leave at least one sheet… KB#213609. Keywords: Format, VBA, Macro, Object, Web

   578. How to Programmatically Change the Format of a User Input After Data Entry This article describes sample Microsoft Visual Basic for Applications Sub procedures (macros) that format a cell after data has been… KB#305565. Keywords: Fonts, Format, VBA , Macro, Web, Discontiguous

   579. How to Delete a Collection of Code Objects from a VBAProject This article contains a sample Microsoft Visual Basic for Applications macro to loop through all the objects in a VBProject , and remove the objects contained in a specific collection. For example, you can remove all standard module sheets in… KB#260993. Keywords: Class, VBA, Macro, Object, VBE, Web