Search results

Thanks! That "what we use" page is great!!

Hi - I love the animated gifs/pictures that Chandoo and the other experts use to quickly show an Excel "how to" or some visual spreadsheet example, such as a sliding "on/off" button. Does anyone here have any good recommendations on how to easily make these? I want to use them for some easy...

Hi Shrivallabha, Thanks for the reply! I was thinking the same thing and went with a double-click event. I really like the code you mentioned asking/confirming whether they want to insert a comment - Cheers! Here's what I'm currently using, but I need to add that option you mentioned and...

Oh! Sorry. That is useful and makes complete sense. I misunderstood "user code", which represents the user initials now and that's great. Thanks again!

Hi Dave, Thanks for the quick reply. I think I'll give that a shot. One question though, was there any reason for the 2 input boxes? I should be good with just one. What I plan on doing now is concatentating their old comments that exist in the cell(s). For example, whatever they entered in...

Hi, This is my first post...I love this site. In regards to my question, I have a spreadsheet that has cells setup for user text/comment entry. For example, Cell T10 has text entered by Bob: "Project on track. Next update will be provided 28MAR13-BH22MAR13" The purpose of this cell is to...

Hi, in regards to reducing the calculation/computation strain on the workbook, do you recommend using index/match vs. indirect for retrieving data? I'm hoping this is the correct place to ask this question :) I googled "indirect" trying to understand the benefits for setting up a new globally...