hi.
unless you are going to do a lot of data input, you may find that your
controls work just as well from the sheet. might be less work and setup. for
me, forms are for input and there is no need to create a form just to hold
command buttons.(although i have done that.)
this is an opinionated subject. others might disagree based on their
preferences.
i might suggest that if you do put your controls on the sheet, use activeX
controls from the tool box , not form controls.

my thoughts
FSt1


"Webtechie" wrote:

I am using Excel XP as a UI for SQL Server 2005 Express.

I will be executing stored procedures
I will read data into Excel from SQL Server
I will have charts, list boxes and several buttons.

Question:

Is there an advantage to using Userforms for this or just placing the tools
on a worksheet and making a pretty form?

The VBA code behind should be the same?

I am leaning toward to just placing the tools on a worksheet and changing
the color and place in a logo.

Thanks.