Using Excel as a Form

  • Thread starter Thread starter Sean
  • Start date Start date
S

Sean

Is Excel a good program to use as a form? Specifically,
can a combo box (on Worksheet 1) be filled with data from
a list on Worksheet 2?

I am an Access programmer but have almost no experience
with Excel. I am trying to weigh the better option for a
form, Excel, Word, or Web Page.

Thanks. Sean.
 
Sean

Difficult to say without knowing the full scope to your project but you can
fill a comb box on a worksheet with a list from another sheet.

To test this open a workbook and on sheet2 make a list in A1:A20. Go to
sheet 1 and draw a combo box from the 'Controls' toolbox and in the property
sheet look for the ListFillRange Property. Set this to

Sheet2!$A$1:$A$20

and the data will appear in the combo box

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Replies in line:
can a combo box (on Worksheet 1) be filled with data from
a list on Worksheet 2?
Click to expand...

Yes, but...
Is Excel a good program to use as a form?
Click to expand...

Not really. I takes a lot of effort and you end up with something
that's not quite like a form and nothing like an Excel worksheet.
I am an Access programmer but have almost no experience
with Excel. I am trying to weigh the better option for a
form, Excel, Word, or Web Page.
Click to expand...

A web page is probably best if you have the architecture and the
know-how, otherwise I'd go for a userform in Excel (could be a
userform in Word, same beast).

--
 
Back
Top