Excel Stopwatch
Create a stopwatch on your Excel worksheet to track hours, minutes or seconds for your task.
top of page
Search
Kimberlee Martin
- Sep 21
- 4 min
One Table or Two? Or Three? Four??
Not sure if you need one table or two in Microsoft Access? Here's a guide.
0 views0 comments
Kimberlee Martin
- Sep 19
- 3 min
Detecting #N/A with VBA
Using VBA code to check for #N/A in an Excel cell. The CVErr function allows you to check for several of the "#" errors in Excel.
3 views0 comments
Kimberlee Martin
- Sep 14
- 3 min
BEEP! An Audible Alarm in Excel
Create an audible alarm in Excel that beeps when a timer expires.
6 views0 comments
Kimberlee Martin
- Sep 5
- 4 min
Do I need a subform on my Access form?
When to use a subforms in a Microsoft Access database
5 views0 comments
Kimberlee Martin
- Aug 8
- 4 min
Scheduling Excel Macros with a Timer
A while back, I wrote about creating a timer in Excel. In that post, I went into detail about my failed attempts to create one, and how I...
18 views0 comments
Kimberlee Martin
- May 5
- 3 min
Port Access Data to SQL Server
Porting Microsoft Access tables to SQL Server
8 views0 comments
Kimberlee Martin
- Mar 13
- 7 min
Access Database Corruption
Dealing with the "database is in an inconsistent state" error message, and other symptoms of Microsoft Access corruption.
13 views0 comments
Kimberlee Martin
- Feb 20
- 4 min
Connections: Linking Access to Access
In recent blogs, I've been discussing the various ways you can connect data between Microsoft products. So far, I've covered Access,...
12 views0 comments
Kimberlee Martin
- Jan 17
- 6 min
Connections: Bringing SQL Server data into Access
Linking to data in SQL Server from a Microsoft Access database
18 views0 comments
Kimberlee Martin
- Jan 11
- 4 min
VBA Dates
Excel and MS Access store dates as numeric fields, allowing for each calculations in VBA.
8 views0 comments
Kimberlee Martin
- Jan 5
- 6 min
Connections: Bringing Excel Data into Access
Create a Microsoft Access table that is linked to an Excel file.
16 views0 comments
Kimberlee Martin
- Jan 3
- 5 min
VBA: Three Ways to Handle Text in Numeric Fields
Users will make mistakes, and some of those will impact your VBA code. Here are three ways you can handle that.
8 views0 comments
Kimberlee Martin
- Dec 22, 2022
- 3 min
Using Access to Clean Excel Data, Part 5
I’ve been covering the use of Microsoft Access tools to clean your Excel data for the past few weeks. Today is the final entry in that...
11 views0 comments
Kimberlee Martin
- Dec 19, 2022
- 4 min
Doubles, but No Troubles
Use VBA to check for nearly identical data in your Excel worksheet.
18 views0 comments
Kimberlee Martin
- Dec 12, 2022
- 6 min
Using Access to Clean Excel Data, Part 4
Use MS Access to find duplicates in your Excel data
10 views0 comments
Kimberlee Martin
- Dec 6, 2022
- 2 min
Auto-replace Text in Excel Cell with VBA
In recent posts, I’ve been talking about validating your Excel data using VBA. I talked about creating a validation harness, which you...
21 views0 comments
Kimberlee Martin
- Dec 2, 2022
- 4 min
Validating Numeric Fields in Excel
Use Excel's Data Validation feature, in conjunction with Excel functions, to validate numeric data.
13 views0 comments
Kimberlee Martin
- Dec 1, 2022
- 5 min
Using Access to Clean Excel Data, Part 3
Use MS Access to clean numeric fields that contain text.
10 views0 comments
Kimberlee Martin
- Nov 28, 2022
- 6 min
Parse Phone and Extension with VBA
Last week, I wrote a blog post about creating a validation harness in Excel VBA. I laid out a structure you can add to your Excel file...
16 views0 comments
CATEGORY
ARCHIVE
bottom of page