3) always the same colors? then I would do it with conditional
formatting. Thats an easy way. You check if the cell is empty and if
not you format how ever you want (background and font).
goepf wrote:
*Brian,
1) show the "control toolbox" toolbar and there you find a command
button to "draw" where you want.
then go to the properties and give that button an nice name and
description (caption)
then go to the code of the button and call your macro from there
with: call AddData
and exit the design mode (button on the toolbar)
2) and 3) sorry I'm in a hurry... *
------------------------------------------------
~~ Message posted from
http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/
~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements