Hi guys need some advice:

I want the students 2 b able to book more than 1 piece of equip out at one time....is it:

a) more easyier to program - to get them to make one booking in the sys

b) easier for user (but appa harder to program) - to let the users make a selection??

on a booking form????

Have you thought about using a Shared Workbook?

Then multiple users can access it at once.

EDIT: Tools-->Share Workbook-->Editing-->Allow changes by more that one User.

Hope that helps,

Smitty

If I understand what you want, you could use a UserForm (relatively easy to setup) to allow booking, but such an approach would require that the student fill in the form for each instrument. Thus, if a student wanted to book three instruments, he/she would click the userform three times.

Another option might be to have Validation dropdown lists in columns (one column for total number of instruments allowed, i.e. if a student could never have more than four instruments at one time, then have four columns with Validation lists for each column. The Validation list would include all instruments.

just some thoughts.

RE: Which Way is Best

Referance use of UserForm

If you used a list control with multi-select option on, then all selection could be made in one hit. You woul have to check the number of selected items if there is a max No.

If ypur new to Excel/vbforms then this will require a bit of effort!

Just some thoughts

MTB