Similar Posts

|

Other ActiveX Controls in Excel Worksheets

ByRick

In an earlier post, we looked at connecting VBA code to command buttons on the Worksheet, the Quick Access Toolbar and the Ribbon.  What about the other ActiveX Controls: The Combo Box, List Box, or Check Box?  How about Option Buttons, the Scroll Bar, Spin button, Toggle button, etc.?  That’s coming up in this post….

|

How to Copy Text to and from the Clipboard in Excel and Access Visual Basic

ByRick

You can record a macro to copy from and paste to the Excel worksheet.  Easy enough.  But what if you have a value in Microsoft Excel VBA that you want to put on the clipboard for another program?  Or you want your code to get text from the clipboard after you copied it there from…

|

How to Use Objects, Properties, Methods, and Events in Visual Basic

ByRick

This is an excerpt from Microsoft Excel 2000 Visual Basic Help. 1.        Objects and Collections An object represents an element of an application, such as a worksheet, a cell, a chart, a form, or a report.  In Visual Basic code, you must first identify an object.  Only then can you apply one of the object’s…

|

How to Pass Arguments Efficiently in Visual Basic

ByRick

This is from Microsoft Excel 2000 Visual Basic Help, with changes and additions. All arguments are passed to procedures by reference, unless you specify otherwise. This is efficient because all arguments passed by reference take the same amount of time to pass and the same amount of space (4 bytes) within a procedure regardless of…