Considering my job is in software documentation and user manuals, I’m not doing very well here. Sorry. I will try to sort this out.
The VBA form has also grown. For each individual value range you can now set:
- bar colour
- display or hide values
- gradient or solid fill
- border yes/no
- border colour independent from the bar colour
So your data bars can look like this:
I don’t know how useful data bars could be with so many formats mixed in, but the possibility is there.
Meanwhile, Metfan has asked me to explain how to install the form he downloaded, so here is a quick guide to doing that.
From Excel you’ll need to open the VBE (alt+F11) then right-click on the project where you want to include the form, probably “personal” so it will always be available. Select “Import File…”
Find where you unzipped the downloaded file and select the *.frm file.
That’s it. You’ll see a new subfolder has been created and the form is there.
Double-click to open the form, right-click to open the code window.
The form now looks like this
and the code looks like code. I’ll try to get around to making a proper page putting everything in one place…