Using Excel as a Form
 

For some reason my department uses Excel as a form program, the higher up's
refuse to use Adobe Acrobat to make them and we end up using Excel. So I have
two questions.

1: We are attempting to have one form that will allow us to send to all
people but it needs to cover all bases: For example: I'm not from GM but just
an example.
I need to start an Excel form with a drop down that triggers other items on
the form or at leasts highlights them: Ok, the entire page would consist of
all the model cars GM makes, Chevy 1500, Chevy 2500, Cadillac CTS,Cadillac
DTS, Pontiac G6, Pontiac Vibe, Buick Lacrosse etc etc: maybe 30 vehicles.
But in the first drop-down that I make I want the user to select Pontiac or
Chevy or Cadillac or Buick and then afterwards allow those models that are
associated with that division to highlight green and the others red. This
way the person interested in Buick only see's the Buick Models highlighted
green? Is this possible with Excel or should I revert to Adobe or Word?

2: When I allow the user to print the page, can I only allow him to select
the area to print and nothing mo One page only?
--
Jeff

Using Excel as a Form
 

Actually, with the need for dependent lists, you're probably better off using
Excel to create the form. Especially if you're going to analyze input data
later.

Anyhow, take a look at www.contextures.com, Debra Dalgleish has compiled a
lot of stuff about drop downs, dependent lists, etc. I think a good starting
point for you is he
http://www.contextures.com/xlDataVal02.html

As for allowing the user to only print a certain area, you can set the print
area through the File | Page Setup menu and use the [Sheet] tab where it asks
for the "Print Area:"

"jeffkeef" wrote:

For some reason my department uses Excel as a form program, the higher up's
refuse to use Adobe Acrobat to make them and we end up using Excel. So I have
two questions.

1: We are attempting to have one form that will allow us to send to all
people but it needs to cover all bases: For example: I'm not from GM but just
an example.
I need to start an Excel form with a drop down that triggers other items on
the form or at leasts highlights them: Ok, the entire page would consist of
all the model cars GM makes, Chevy 1500, Chevy 2500, Cadillac CTS,Cadillac
DTS, Pontiac G6, Pontiac Vibe, Buick Lacrosse etc etc: maybe 30 vehicles.
But in the first drop-down that I make I want the user to select Pontiac or
Chevy or Cadillac or Buick and then afterwards allow those models that are
associated with that division to highlight green and the others red. This
way the person interested in Buick only see's the Buick Models highlighted
green? Is this possible with Excel or should I revert to Adobe or Word?

2: When I allow the user to print the page, can I only allow him to select
the area to print and nothing mo One page only?
--
Jeff