Data Entry Form

[Dave]

I seem to remember there was a feature in Excel for a data entry popup form.

I have a simple table of records with about 8 columns and I would like to
have a form to take the data entry.

I am in Excel 2007

Thanks for reading
Dave

 

[Peo Sjoblom]

It is still there, you can add it to your QAT, click office button>excel
options>customize, then select commands not in the ribbon from the choose
commands from toolbar, scroll until you see form and add it



--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

 

[Shailesh Shah]

Besides you may download one addins"Excel Menu -2003" from Addins Page of
below site which installed Excel-2003's File Menubar , Standard Toolbar &
Formatting Toolbar in the Addins Tab.

http://in.geocities.com/shahshaileshs/


Regards,

Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
If You Can't Excel with Talent, Triumph with Effort.

 

[Khalil Handal]

Hi,
This looks interesting to me!
How cna this be done n Excel 2003?

 

[Dave]

Just what I needed. Thanks much
dave

It is still there, you can add it to your QAT, click office button>excel
options>customize, then select commands not in the ribbon from the choose
commands from toolbar, scroll until you see form and add it



--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

 

[Dave]

Thanks for the tip

Dave

Besides you may download one addins"Excel Menu -2003" from Addins Page of
below site which installed Excel-2003's File Menubar , Standard Toolbar &
Formatting Toolbar in the Addins Tab.

http://in.geocities.com/shahshaileshs/


Regards,

Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
If You Can't Excel with Talent, Triumph with Effort.

 

[Dave]

Do not remember where it is in 2003 but I know it is there.
I remember doing this with Excel 98 or 2000 but never would have found it in
2007.
I think it will be easy find in 2003 and if memery server from the menu
Menu->Data->Forms

dave

 

[Khalil Handal]

I will try it. Thanks

Do not remember where it is in 2003 but I know it is there.
I remember doing this with Excel 98 or 2000 but never would have found it
in 2007.
I think it will be easy find in 2003 and if memery server from the menu
Menu->Data->Forms

dave

 

[Karen Morris]

Hi Peo,

I am creating a form in Excel 2007, placing ActiveX combo boxes on a sheet next to a question that prompts their choices from the pull-down menu of the combo box. The gathered data is being linked to a single-row at the bottom of the sheet (which I can hide from user's view) and will be transfered to a data depository master sheet--where it can be used as hard-typed (i.e., not linked data) via a macro.

I am having two problems:

1) I cannot get an ActiveX text box to function such that it allows the user to type text input into it. The text box is behaving as a "display only" text box. I have been looking in Properties for this activeX control and cannot, for the life of me, figure out how to set the properties so that the text box allows input by the user;

2) my second issue is how to have the finalized form--developed on a spreadsheet--display without all the unused columns to the right of the printable page showing in the user's window. I'd also like to hide the greyed cell lines from the user's view

Thanks,

K Morris

 

[Ron de Bruin]

Hi Karen

1) Press the Design button on the developer tab

2) On the View tab in the Show/Hide group Uncheck gridlines

OR : Office button>Excel options..Advanced

See display options for this sheet
Uncheck gridlines

You can hide the columns that you not use if you want



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


in message news:[email protected]...