Find and mark serial numbers

Closed
brihaff - Mar 1, 2011 at 01:48 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 1, 2011 at 06:14 AM
Hello,


Is there a way I can have excel open a find box and once i do a serial number scan it will find the serial number let say in D5 then put an x in E5 right nect to the match?

Thanks


Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 1, 2011 at 06:14 AM
you would need three building blocks in vba
1. an inputbox to allow user to enter the value to be searched
2. once validate that value is not null, you need to use find function to locate that value
3. once the value is location, then you can make the change
0