Skip to content
A quick reference to VBA code
Search
Dissecting Excel VBA
Menu
Build a Foundation
Chapter 1: Knowing your tools
Developer tab
Visual Basic Editor
Customizing VBE
Immediate window
Object Browser
Macro recorder
VBA Help system
Chapter 2: Knowing the places to store your VBA code
Types of VBA modules
Sample procedures in a standard VBA module
A simple Sub procedure: Color banding
A sample procedure in a workbook module
Chapter 3: Programming fundamentals in VBA
Data types
Debugging
Chapter 4: Some other tips on VBA programming
Changing workbook appearance
Cell formatting
Sheet tabs
Gridlines
Status bar
Workbook views
Ribbon
Hide and unhide the Ribbon
Activate a Ribbon tab in two different ways
The SendKeys method
XML and VBA code (in Excel 2010 and later)
Working with ranges
Refer to ranges
The Range property of a Worksheet object
Range (Cell1)
Range (Cell1) with one or more range operators (colons): Range(“B2:C5”); Range(“B:B”); Range(“2:5”); Range(“B2:C5:D1”)
The Cells property of a Worksheet object
Some properties and methods of a Range object
The Parent property
Navigate in a worksheet with the End property
The Replace method
The Replace method
Convert a column number to its column letter
Padding cells with specific characters to certain length
Prompting a user
To select a range
Auto-fill a range
Auto-fill a range
Convert text values in a range to number values
Export a range of cells as a comma-separated-values (CSV) file
Working with sheets, workbooks, and files
Working with sheets
Refer to a sheet
Loop through all sheets and selected sheets
Working with workbooks
Create a new workbook
A new default workbook
Working with files
Prompt a user for the filename of a file and the filenames of multiple files
Prompt for the filename of a file
Working with controls and automation
Working with controls
ActiveX controls on a worksheet
List box
Select items in a list box
Combo box
Select an item in a combo box
Automation
Working with the Word application
Paste data from an Excel workbook to specific locations on a Word document
Supplementary files
Welcome to Excel VBA code
Home
Prompting a user
Prompting a user
To select a range
To enter a value
Share this:
Twitter
Facebook
Like
Loading...
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here:
Cookie Policy
Subscribe
Subscribed
Dissecting Excel VBA
Sign me up
Already have a WordPress.com account?
Log in now.
Dissecting Excel VBA
Customize
Subscribe
Subscribed
Sign up
Log in
Copy shortlink
Report this content
View post in Reader
Manage subscriptions
Collapse this bar
%d