Excel databases. I'm lost. Curses.
 

G'day.

A few years back, I created an excel database.
First I created a from and I could toggle to the database via a tool button.
If I clicked on the row I could toggle back to that data entries in form mode.
Something else.
I changed the row and column headings.
The headings became the headings on the form instead of A, G, C, D, etc.
Instead of these grey cell references automatically given by excel, not
names in a cell underneath. Hope that makes sense.
Now that I need to create something similar again for personal use, I can't
remember how I did it.
It's driving me insane..r.
Please help.
Forever in your debt, etc, etc, etc.

Bridget

Hi Bridget,

Try:

Data | Form


---
Regards,
Norman



"Bridget" wrote in message
...
G'day.

A few years back, I created an excel database.
First I created a from and I could toggle to the database via a tool
button.
If I clicked on the row I could toggle back to that data entries in form
mode.
Something else.
I changed the row and column headings.
The headings became the headings on the form instead of A, G, C, D, etc.
Instead of these grey cell references automatically given by excel, not
names in a cell underneath. Hope that makes sense.
Now that I need to create something similar again for personal use, I
can't
remember how I did it.
It's driving me insane..r.
Please help.
Forever in your debt, etc, etc, etc.

Bridget