Daily posts of Excel tips…and other stuff
Archive for the ‘CodeCritic’ Category.
I have a cell with data validation. It's set as an in-cell dropdown list and contains two items: Yes and No. I want to make it so that I can double click on that cell to toggle between yes and no. But wait, that's not good enough. What about longer lists? [...]
A couple weeks ago, I had more than 1,200 emails in my Inbox. Now I have none. I've been using, and tweaking, my Outlook Tags macro to clean and maintain my mail. In addition to handling new mail in a timely manner, I processed a couple hundred old emails every day. [...]
I've been using my Outlook Tags system this week and it's been very nice. I've made some changes over the week and I thought both people who were interested in this might be interested in the changes as well.
I changed the Tags textbox into a combobox as, I believe, Ken Puls suggested. I [...]
I've recently started using del.icio.us to manage my bookmarks. I don't have any interest in social bookmarking, but I like that I can get to my bookmarks from any computer and I love the tagging system. I set my home page to my frequent category and I can easily access other categories from [...]
I need to save the names of one or more files in the custom document properties of a workbook. I don't want to create a separate property for every filename. I thought about saving a comma-delimited string, then parsing it out. It would look like:
file1name,file2name
Another idea I had was just save one [...]
JWalk wrote about a Keyless Entry Hack. "That shouldn't be too hard to duplicate", I thought. I get 3,133, but I have four duplicate numbers. Here's part of my immediate window.
How do I get rid of those duplicates?
Sub MakeKeyCombo()
Dim i As Long, j As Long, k As Long, [...]
When I do some screen shots, I need to hide the cursor. Not only do I want no cell selected, but I don't want the column or row headers highlighted - so I can't just page down for instance. Manually, I was using Ctrl+End to get to the last cell followed by a [...]
I have two paths and I want to determine a path that encompasses both directories. For instance, if I have
C:\DKInc\Invoices\
C:\DKInc\Memos\
then I want to return C:\DKinc\. This is the most restricted folder I can search, including subfolders, that will include both the Invoices folder and the Memos folder. I thought there would be [...]
