Data Entry Form

  • Thread starter Thread starter Dave
  • Start date Start date
D

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
 
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)
 
Just what I needed. Thanks much
dave
Peo Sjoblom said:
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)
Click to expand...
 
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
 
I will try it. Thanks

Dave said:
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
Click to expand...
 
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
 
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]...
 
Back
Top