August 2006

Pattens

some cool pattens:

http://bgmaker.ventdaval.com/

Good for back drops in dictor apps ;-)

And as pattern fills (in shapes) are getting binned from 07, there will be a use there as well!

Free VS2005 – [trial]

If you’ve been following xlDennis’ excellent set of post over at DDOE then you might be tempempted to try your hand at a .Net managed code addin. If you do, this might be of intrest to you:

http://www.microsoft.com/emea/msdn/visualstudio/enxu/getthetrials/

You can download it too if you scroll down the page:

List Box Resizing problems

Ran in to an old friend today, and it took me a while to remember what to do. After adding a list box to your user form, you’ll want to resize it so that it looks nice. At design time you can get all your controls lined up without too much effort. Like this:

DesignTime.JPG

However when the form is run, the list box automatically resizes itself! Like this!

RunTime.JPG

The answer is to change the a default setting, the “IntegralHeight”, and problem solved. The difference is that now your list box will show parts of lines that don’t fill the list box exactly, rather than resizing to accommodate only whole lines.

fixed.JPG

In cell graphing

A few ideas have been floating about recently, each have there own pros and cons here a new one to me, looks good!

http://www.juiceanalytics.com/weblog/?p=239

Icons, Icons, Icons

Adding the finishing touches to a user form cab be fun, here are some cool Icons to help you out!
particularly noteworthy

http://www.yellowpipe.com/yis/download/free-icons.php?seenIEPage=1

and a really full list here:

http://www.maxpower.ca/free-icons/2006/03/05/

UPDATE, UPDATE, UPDATE:

there are some amazing works of icon art here too:

http://interfacelift.com/icons-win/index.php?sort=date