G
Guest
How do you create forms in Excel 2007? I can't find the Forms Toolbar or
anything that resembles it.
anything that resembles it.
B
Bernard Liengme
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
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
M
Misty
I have a question after you display the Forms Control box. I did not get a
Forms Toolbar.
Why are three (text field, Combo List-Edit, Combo drop down) grayed-out?
Anyone know how to get them available for use?
Forms Toolbar.
Why are three (text field, Combo List-Edit, Combo drop down) grayed-out?
Anyone know how to get them available for use?
K
KMorris
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
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