Bernard,

My experience with forms is limited to MS-Access. I understand that
creating forms in Excel is going to be somewhat different. I've got as far
as the following--in my attempt to create a form in Excel 2007--however, I am
stumped at how to get the Form I am developing to know what data goes with
each combo box, text field, etc, that I place onto the form.

I want to create a form that allows me to choose whether to use a combo box,
a text field, etc., and to be able to write and edit my labels on the form as
well as to add text and graphics onto the form, rather than be stuck with the
generic scroll-bar thing one gets by highlighting the data labels and
clicking on "Forms".

I have opened the workbook and selected the tab and even the data labels I
want to use for my form; then I have done alt+F11 to get the forms editor
open. A nice Form editor opens--quite similar to the design view of forms in
MS-Access--however, the problem is I can't figure out how to tell this forms
editor that when I place a combo box on the form, for example, I want that
combo box to draw on data in a specific range.

I went to a huge bookstore here in Toronto and went through all the Excel
2007 books they have. I was--and am--appalled and sicouraged that most of
them don't even include "Forms" in the index. When they do mention Forms is
is some very sparse instructions about how to get that very limited data
entry thingy to be auto-generated. Help! Please. :)

Karen Morris

"Bernard Liengme" wrote:

Do you have a Developer tab on ribbon?
No - click Office Button; click Excel Options and on Popular dialog, 3 down,
check "Show Developer on ribbon"
Click Developer tab on ribbon; use the Insert tool to display Forms Toolbar
and Active X Controls
Hope I understood question correctly
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"hairball" wrote in message
...
How do you create forms in Excel 2007? I can't find the Forms Toolbar or
anything that resembles it.