Vba | Get Digital Help

Popular categories

Conditional formatting

Drop down lists

Dashboard reporting with excel This e-book teaches you how to create your own Excel dashboard reports, starting from scratch. Learn how to create mini-charts, how to use Excel's Camera tool, how to set up Excel databases, and a lot more.

Excel Worksheet-Formula Add-Ins allows worksheet formulas to change chart settings. For the first time ever, your formulas can create traffic-light charts, highlight chart elements, assign number formats, and much more.

Get Digital Help > Excel > vba

Archive for the ‘vba’ Category

Heat map using pictures

Yet another excel calendar

Copy/Rename a file (excel vba)

Change picture (vba)

Heat map calendar

Substitute multiple text strings (vba)

Move a shape (vba)

Dynamic data labels in a chart

Highlight a column in a stacked column chart

Highlight a bar in a chart

Lookup multiple values in one cell (vba)

Run a macro from a drop down list (vba)

Hide specific columns (vba)

Change bar color in charts (vba)

Copy each sheet in active workbook to new workbooks

Copy excel table filter criteria (vba)

Excel calendar (vba)

Use filtered table values in a drop down list (vba)

How slow is ReDim Preserve?

Extract cell references from all cell ranges populated with values in a sheet

Use a mouse hovering technique to create an interactive chart

Sort values in a cell using a custom delimiter (vba)

Quickly create links to sheets, tables, pivot tables and named ranges in a workbook

Create links to all sheets in a workbook

Quickly create new sheets (vba)

Insert hyperlinks to all files in current folder

Plot buy and sell points in an excel chart using two moving averages

Add buy and sell points to a stock chart

Interactive chart in excel (vba)

Sort values in a table (vba)

Normalize data, part 2

Search two related tables simultaneously (vba)

Create comments in cells whose value is larger than the column width

Learn how to return values depending on udf deployment (vba)

Select a cell in a table and the chart updates automatically (vba)

Excel template: Getting Things Done (vba)

Disable autofit column widths for all pivot tables in a sheet

Vba macro: Normalize data

Add values to different sheets (vba)

Add values to a table (vba)

Use a drop down list to extract and concatenate unique distinct values

Add or remove a value in a drop down list

Open excel files in a folder (vba)

Copy table design settings

Auto populate a sheet

Toggle a macro on/off using a button

Use a drop down list to select company info in header (vba)

Automate data entry (vba)

Apply data validation lists dynamically (vba)

Workbook log (vba)

Categorize data entry values (vba)

Auto resize columns as you type

Copy a cell range whose size is likely to change from time to time (vba)

List all open workbooks and corresponding sheets (vba)

Basic data entry (vba)

List all tables and corresponding headers in a workbook (vba)

Working with combo boxes (Form Control) using vba

Excel vba: Filter a table using the selection change event

Extract unique distinct values from a filtered table (udf and array formula)

Copy selected rows (checkboxes) (2/2)

Excel vba: Add checkboxes to a sheet (1/2)

Add values to a data validation list (vba)

Follow hyperlinks in a pivot table

Populate a list box with visible unique values from an excel table (vba)

Excel vba: Populate a combo box (form control)

Excel udf: Looking up data in multiple cross reference tables

Excel 2007 vba: Create a custom-made item on the shortcut menu

Excel udf: Sumif across multiple sheets

Excel vba: Select cell A1 on all sheets before you close a workbook

Excel udf: Import historical stock prices from yahoo

Excel recursive udf: List files in a folder and subfolders

Excel toolbox: Save your custom functions and macros in an Add-In

Auto refresh a pivot table in excel

Excel udf: Filter unique distinct records (case sensitive)

Excel udf: Filter unique distinct values (case sensitive)

Excel vba: Create dynamic conditional formatting

Excel udf: Combine cell ranges into a single range while eliminating blanks

Excel udf: Word frequency

Excel udf: Fuzzy lookups

Merge matching rows in excel

Excel udf: Find numbers in sum

Excel vba: Use text qualifiers to make text to columns conversion easier

Excel vba: Create a Print button

Excel vba:Select and view invoice

Excel vba: Populate listbox with unique invoice numbers

Excel vba: Edit invoice data

Excel vba: Save invoice data

Excel vba: Select value based on time and date

Excel udf: Remove duplicates from a large dataset

Filter unique distinct words from a cell range in excel (udf)

Filter duplicate words from a cell range in excel (udf)

Populate cells dynamically in a weekly schedule in excel

Calculate your stock portfolio performance with Net Asset Value based on units in excel

Consolidate sheets in excel (vba)

Automate net asset value (NAV) calculation on your stock portfolio (vba) in excel

Calculate your stock portfolio performance in excel

Categorize values into multiple columns using vba in excel

Split data across multiple sheets in excel (vba)

Calendar with scheduling in excel 2007 (vba)

Dynamic stock chart in excel – Add date ranges

Create a dynamic stock chart using a web query and a drop down list in excel

Create a unique distinct list of a long list without sacrificing performance using vba in excel

Scan stock markets in excel

Stock alerts in excel

Identify missing values in a column using excel formula

How to extract a unique distinct list from a column in excel

Filter records between two dates

« previous entries

Subscribe
Blog updates by email:
Welcome! I am Oscar and here to help you! Feel free to comment and ask excel questions.
Don´t forget to add my RSS feed and subscribe to new blog articles by email.
Recent Comments
- Chetan Sonawane on Identify missing values in a column using excel formula
- Daniel Ekweh on How to return multiple values using vlookup in excel
- NARAYAN on Merge two columns with possible blank cells in excel (formula)
- Rudy on Interactive candlestick chart
- Richard on Search for a text string in an excel table
- Rudy on Interactive candlestick chart
- Chetan Sonawane on Interactive candlestick chart
- Interactive candlestick chart | Get Digital Help - Microsoft Excel resource on Use a mouse hovering technique to create an interactive chart
- Yuri on Change chart data range using a drop down list (vba)
- Carrie Hui on Count unique distinct values that meet multiple criteria in excel
Recent Posts