Archive for the ‘UI Design’ Category.

Feeling good about an Office Marketplace event

Office Marketplace showcases one of my add-ins, TM Calculator, on hit home page as a “Popular Download.”

VBA Userform tip

I don’t know many people know this, but I find it extremely useful when I’m designing a form.
If you select a control, you can then press the TAB key to cycle to the next control (and on) to see what the flow of the form is, just like if you were using the form live. [...]

Conditionally Formatting Command Buttons

I’m designing a data entry form that uses the dynamic table as described in Professional Excel Development. It basically uses conditional formatting to “open” a data entry line when the one above is has something in it.
I want to put a command button on every line so the user can optionally do a special [...]