Looking at the new colour themes in Excel 12 reminded me of a tool I put together a while ago. It’s a colour pallet type tool which lets you build a set of colours in the same range – it’s useful for designing report and the like. Anyway here it is – the help tells you what to do.
I am in the middle of updating a set of business tools used within the company I work for. The particular code I’m working on deals with post codes, it makes an attempt to correct invalid postcodes and points out one which seem suspect. A couple of things struck me about the time I will spend developing this code.
What benefits does your work offer to your company? How do you quantify and justify your time?
Hi, Been really busy both at work, and at home recently so I have not had as much time to blog as I would have liked. Things are still very very very hecktic, but, I'll try hard to put some posts up... to wit:
You can use the Shell command to run programs on your pc, this code run the windows calulator for eaxmple:
The last arugment can be passed the following values:
Value Value (string) Result
1, 5, 9 vbNormalFocus Normal with focus
2 vbMinimizedFocus Minimized with focus
3 vbMaximizedFocus Maximized with focus
4, 8 vbNormalNoFocus Normal without focus
6, 7 vbMinimizedNoFocus Minimized without focus
A very big thank you to Simon over at www.doodleblog.co.uk for the new masterhead, very cool I'm sure you'll agree.
Thanks Simon!
UPDATE!
If you downloaded the example file, you may have noticed that it didn't quite work properly - somehow a line of code had gone missing - I've updated the example file now so it should work ok.
---------------------
I have a report file I send to colleges, I don't want it to look like "just another spread sheet", so I've put some strong formatting and images in, when I'm ready I send it out as a PDF. It's quite nice a looks good. There is a bit of a problem. Part of the report is made up of a set of merged cells, I used this space to add a few sentences, but typing like this in Excel is a bit of a pain.
To make the process a bit simpler I knocked up a simple user form, in which I can type in a more naturally way, I can spell check it right there in the form and them send the whole lot back to an excel range, cool!
I think this implementation of the spell checker falls somewhere between the one suggested by Dick, and Jons [see here].
Anyway here is a demo file.