bet noboby knows!...lol
Posted by andy evans on November 13, 2001 5:44 AM
Ok, heres what I need
I have a list of about 30 items of hospital equipment for loan. They are on a spreadsheet and can either be on loan or in stock (out or in).
For example there are 5 x junior wheelchair jw1-jw5
5x medium wheelchair mw1-mw5 and 7 x adult wheelchair aw1-aw7
I want to use a user form with a combo box so that when someone chooses say junior wheelchair from the list it looks at the right list jw1-jw5 and then looks in the column next to each one until it finds an entry that is 'in'. At that point i want to change the entry to out and use input boxes to add patient name address etc (I pretty much know how to do that stuff)
The bit I cant crack is getting vb to find a range then go through each antry and the one next to it until it finds the required answer then sets that cell as active.
Can it be done?
Its a project that has been set by an exam board for my students and I don't have to solve it this way but it would be nice.
thanks in advance