FSt1,

Thanks for your opinion.

I know to put ActiveX tools.

I would have one worksheet which I would present to the user as a main page.
It will have about four buttons.

One button to read some data.
One button to parse a text file.
One button to review some charts.
One button to input some data.

I will either have each button go to a range on the worksheet (formatted
with listbox, charts and/or input boxes) or just bring up a userform.

Again, thanks for your thoughts.



"FSt1" wrote:

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.