Tom’s Tutorials For Excel: Highlighting the Current and Prior Selected Cells.
I previously posted this example for highlighting the selected cell.
Today, here is how you can highlight not only the current cell, but the cell you’d selected before you selected your current cell.
…
Tom’s Tutorials For Excel: Deleting Duplicate Records
When you have a list of data, sometimes it is not enough to simply delete rows with duplicated information based only on the items in one column. Multi-column lists can have duplicated records based on the fact that every item in every column of a row’s data matches that of another row’s entire data,
…
Tom’s Tutorials For Excel: Identifying Your Active Window’s Top Left Cell
Here are a few macros that identify the top left cell of your active window’s spreadsheet.
The first example relates to this picture, where cell HX63524 happens to be the top left cell in the active window.
…
Tom’s Tutorials For Excel: Populating TextBoxes From Last Row Upwards
When you have a list and you want to populate userform TextBoxes for, say, the last 10 records of the items in that list, here’s how.
In the above picture,
…
Tom’s Tutorials For Excel: Using an InputBox to Find a Row, Column, and Address
This blog entry shows many examples, such as…
• Include a default entry in an InputBox.
• Trap the Cancel and OK buttons in an InputBox.
• Test to find an InputBox entry in a worksheet cell.
…
Tom’s Tutorials For Excel: Summing Varying Ranges Along One Row or at Each Next Row
Sometimes you want options in your VBA arsenal for requests to show results in ad hoc fashions.
In the picture, a table has several columns, each containing a varying count of numeric entries.
…
Tom’s Tutorials For Excel: Verifying Your Internet Connection
With the help of an API declaration, here’s a method for verifying if the active workbook’s system is connected to the internet.
Thanks to MS Excel MVP Mike Alexander at Datapig Technologies for his help with this to include wireless connections in the verification process.
…
Tom’s Tutorials For Excel: Inserting a Picture at a Specific Cell on Multiple Worksheets
Suppose you have a workbook, with several worksheets that often require your company logo to be inserted at a particular cell’s location. Assuming…
• You want the picture at the top left corner of cell D3.
…
Tom’s Tutorials For Excel: Mousing Over a Cell to Run a Macro
Here is how you can trigger a macro by mousing over a range of cells.
This is accomplished without any assistance whatsoever from ActiveX controls or any embedded objects. The cells being moused over (not selected,
…
San Francisco, California
1-925-310-4170
tom@atlaspm.com
Tom’s Tutorials For Excel: Updating a Comment to List Unique Items
Tom’s Tutorials For Excel: Updating a Comment to List Unique Items
Here is how you can automatically update a comment that shows unique items in sorted order from the larger worksheet list, whenever a new unique item is added to that list in the worksheet.
In the pictured example,
…
Read more ›
Tags: Analytics, Big Data, Business Intelligence, Cells Ranges Lists, Comments / Screen Tips, Data Science, Duplicates Uniques, Excel Expert, Excel Guru, Macros Events Classes API, Microsoft, Microsoft Excel, Microsoft MVP, Microsoft Office, Tom Urtis