advanced search

[Guest]

Hello People
I am trying to search an excel database, with the following formate
color weight
22 33
76 33
22 55
so I can enter 22, 55 and get the cell 22, 55 to activate
I tried to write a VBA code to do this, but I can't get it to work
Please help

Thank you in advanced

 

[Chris Davison]

On 2002-02-28 11:01, Anonymous wrote:
Hello People
I am trying to search an excel database, with the following formate
color weight
22 33
76 33
22 55
so I can enter 22, 55 and get the cell 22, 55 to activate
I tried to write a VBA code to do this, but I can't get it to work
Please help

Thank you in advanced

what do you mean by "activate" ?

thanks
Chris

 

[Guest]

sorry,activate is to have the cells selected
Could you help me out ?

 

[Chris Davison]

ahhh, I see. Nope, not me. I'm as successful with VBA as Ben Johnson is with a urine test.
Lots of VBA experts here though, I'm sure they'll be along soon.

Good luck

 

[Guest]

Thank you Chris for trying to help

 

[Guest]

[No message]

 

[Guest]

[No message]