Remove/Hide option from combobox list item

Hi,

I am developing a small app for my office. we have a Laptop borrowing pool and I have a small user form with a number of details including a combobox linking to a sheet with an array of loanable items.

I'm looking to hide or grey out each item as a user 'borrows' it. I would also like someway of resetting this option when it is returned, a button on the spread sheet, or form, only accessible by certain individuals would be ideal.

I'm just wondering if something of this ilk is doable and if so, how do I go about it?

Thanks!

Easier to provide a solution for this sort of thing if we can see what you have so far.
Any chance you could post the workbook? Desensitize names, numbers etc. if necessary.

BSB

Do you record anywhere that a piece of equipment was returned?

If you did then you could use that to build a dynamic list on your "Resource" sheet, then use that to populate the ComboBox rowsource.

BSB

At current, no. Although this is something that I have been trying to implement. I was thinking about deleting the item from resource worksheet when the user selects it and having a button next to each item that will repopulate the field. A sort of manual 'returned' button if that makes sense.

I think having a way to return the item on the form may be a good idea. I will look into that.

If the "Scots ID" is unique then you could add a function to recall details of an equipment loan based on that then have another field on the UserForm to add the "Returned Date" and update the relevant row. Combined with my earlier suggestion you could make this work without too much fussing around.

Unfortunately I'm unable to show you what I mean as your form uses the Date Picker and I do not have that available on my machine, so the form doesn't work for me.

BSB

Thanks,

It sounds like that's the way to go. I only touched on VB stuff in Uni and that was a while ago so I'll go away and test my google skills.

Cheers

Gordon

Good luck with it.
Feel free to shout for help if you need. That's what we're here for

BSB