Return to index: [Subject] [Thread] [Date] [Author]

RE: Excel: Custom Data Entry and Edit Form

[Subject Prev][Subject Next][Thread Prev][Thread Next]
One way is to set the spreadsheet for "data entry" mode. To do this, you select the cells you want to use for data entry and then unlock those cells. To do this, do the following: Format|Cells|Protection then make sure the "Locked" checkbox is unchecked. Then you protect the worksheet. After doing this, you can only tab to the unlocked cells, skipping over the calculated fields.
I don't know if this achieves your goal.
Bill Allen, S.E.


 -----Original Message-----
From: Tripp Howard [mailto:tripphoward(--nospam--at)]
Sent: Thursday, March 14, 2002 11:21 AM
To: seaint(--nospam--at)
Subject: Excel: Custom Data Entry and Edit Form

For all you excel users out there, see if you have any suggestions.

Say I have a project where I need to design 10 steel beams.  I can create a spreadsheet that will do all the design checks for a given set of input data, thats no problem, but after designing 10 beams I would have 10 different spreadsheets.  

I would like to create a workbook where I can enter the input data sets using a custom form which would store the data in a table on one of the other worksheets in the same workbook.  Then in my calculation sheets I would select which data set to calculate on using a combo box to pick the data set.

I have no probelm using the combo box to lookup the data in the table, but does anyone know of a simple (i.e. no VBA) way to create a form that will allow me to enter and edit the data in my data table?

Thanks for your help.


Tripp Howard

Do You Yahoo!?
Yahoo! Sports - live college hoops coverage