Creating a Record Entry Bar - Possible?

I am trying to create a form of database on Excel for Mac. I don't have a clue how to do this, or even if its possible, but I thought if there was a way, here was the best place to find it.

I am creating a list of members for a Scuba Diving Club. The idea being that there is one row (which effectively just acts as a toolbar) within the sheet, containing dropdown boxes, and text boxes. The user can then use the dropdown boxes and text boxes to enter in the details of the member, then press the 'Add to Database' button, and the information filled in, would then appear in the list of records below, and the 'toolbar' would be cleared, for another person to be added. I also need the code to give each 'entry' into the records a 'Member ID' which will obviously start at '1' and keep going up infinitely, adding 1 to the number each time.

Also, If possible, each 'entry' would be given a little 'Delete Member' button to the right of the entry, which would appear as an entry was added, and clicking this button would delete that row.

I know this all sounds very confusing, so to help I have attached a copy of the sheet, so feel free to do what you want to, and if you are able to find a solution, send a copy of it back, and I would be endlessly grateful!

If anyone is able to help me, I would not be able to thank you enough.

Thanks in Advance.

Hi,

Is there any reason for the "toolbar" approach you have in the attachment rather than creating dropdowns in the rows themselves?

Oh it's possible and without too much effort. The only thing I'm not sure about is the "delete buttons".
I think that having buttons to do that would be over complicating something that is easy enough to do by just deleting a row in the usual manner.
Are they a necessity?

Also, are the merged cells a necessity for what you plan to do with the data?
They also just make things more difficult than they need to.
i.e. the "Type of Member" cell spans 5 columns rather than just one wide column.

Have a look at the attached, but keep in mind I am FAR from expert in the art of writing VBA so I'm sure there's some clever soul out there that will be cringing at my attempt.

Seems to do what I think you're after though...

No problem

Errrm... Yes, all of that's possible. Leave it with me. Got to go feed the kids but will sort it as soon as I'm done.

Do you want there to be no borders until that row is filled out?

How's this?

I think calling it 'expertise' may be pushing it a little.. especially when it comes to VBA. But I'm glad it works for you.

I fancy going scuba diving now