EXCEL Mask for data entry

[Bill]

I don't have MS Access but I want to create an Access
type Entry Mask for the entry of data into appropriate
cells within a background work sheet.
I want to create this as a simple entry form for non
Excel users.
The form would have 6 column and there would be a need
for a look up table so when I entered an equipment asset
number, its appropriate serial number would auto insert?
Am I being too hopeful that such a facility exists within
Excel? If by chance it does, where would I look for
instructions?
Hopefully
Bill

 

[Guest]

This is very possible in Excel but there are a few things
to understand first.

The simplest way is simpy to modify a worksheet so that
only some cells are not locked and have validated values
(look up 'protecting sheets' , locking cells and cell
validation in help if you do not know how to do this).

You will then need to have some hidden cells to create the
values you need. These would use lookups (probably
VLOOKUPs) to find the relevant data from a reference
table, probably on another worksheet. Again look
up 'vlookup' in help.

I would not recommend you to start using forms in excel
utnil you have a good grasp of visual basic etc..

 

[Frank Kabel]

Hi
some things you have to do
See the following links for some direction:
1. Create a listbox:
http://www.contextures.com/xlDataVal01.html

2. Autofill the serial - number:
http://www.mvps.org/dmcritchie/excel/vlookup.htm

3. Dataform:
http://j-walk.com/ss/dataform/index.htm