looking for values

[Robert Couchman]

i need a combobox to look for the value to insert into the
combobox,

it will need to look at the dates in a range, then the
time in the range, then the panel in the range.

if all these match the location of the combobox then it
will put the persons name into that box.

### is there any way that it would be able to erase
details in cells on that row if needed? ##

or put new details in if selected??

thank you,

Robert Couchman
([email protected])

 

[Tom Ogilvy]

Just look at the help example for FindNext. Find the most restrictive
value, then check the other two columns, if they all match the specified
values, then add the name, else continue to search.

 

[Robert Couchman]

thank you tom,

i dont suppose you know of any way that i would be able to
tell the computer to find the values as soon as
information is typed into the textbox? and then when the
combobox changes it puts the details in the appropriate
record (after deleting the details out of the old record!)

e.g. member 3 is selected for 10am
when member 4 is selected 10am is deleted from 3's
record, then puts 10am into 4's record

thank you,

Robert Couchman

 

[Tom Ogilvy]

I am sure it can be coded quite easily, but I would have to make a lot of
assumptions about where things are on the worksheet, about where the
controls are located, about what the user is doing, etc, etc.

So it would be a waste of time.

for 10 AM means what. Where is 10 AM specified
member 3 is selected where
What happens when 10 AM becomes 11 AM?

Where are the controls located. Where is the data located. Your pevious
question said match on date, time, panel - but you are only talking about 10
AM.

See, more left unsaid than said.