Developing part database, need to know how to search from command button

[creekybones]

Hi All,
First post, excellent forum.

I am developing a spread sheet that has a lot of part numbers with stores location attached to them, I would like use the find function in excel but I don't want to use a separate dialogue box. eg If I enter any text in cell A1 then click a command button. The code in the button will work exactly like the excel find/next feature and search the entire sheet and select the cell with the found text. the reason for not using the excel find feature is that the sheet will be used on a touch screen with a on screen key board and if I use the standard find feature , there maybe confusion when people open the dialogue boxes out of sequence.

Or it maybe easier to search the workbook and display the whole row data at the top of the sheet in a blank row.

I hope I have explained OK.

Is this possible?

Thanks in advance

Dan

[Winon]

Hi creekybones,

I think it would be a very good idea if you could provide us with a sample WorkBook, stripped of sensitive data, for us to have a look at, to see where we can help you with your Code.

[creekybones]

Hi Winon
Thanks for the quick reply,

Attached is a stripped down copy of the file.

Thanks for your help.Store Data.xlsmStore Data.xlsm

[Winon]

Hello again creekybones,

I trust that you will find the attached WorkBook doing what you have asked for.

Also see the "Please consider" notes at the bottom of this Post.

[creekybones]

Hi Winon,
Thanks for your help, Works fine. Maybe a cheek, But can the search be modified to search multiple columns, text and numbers? I need this to work exactly like the standard Excel search feature. Or is that not possible?

Thanks Again.

Dan

[Winon]

Hi Dan,

What you are asking for would, in my opinion, be a mammoth task. If you need it to work exactly like the standard Excel search feature, then maybe you should stick to what you originally had.

Sorry, but I cannot duplicate the standard Excel search feature with VBA. That would be like re-inventing the wheel whilst it is available, if you understand what I am saying.

As a matter of interest, why would you want to search for something, anywhere else, while it is in a specific location ?

[creekybones]

Hi Winon.
Thanks for the reply. I agree with what you have said. The only reason I ask is due to the guys searching for the part locations may not have a part number so may just search for a description or make etc to find the part.

Anyway thanks for your help. It has been a steep learning curve for me and this forum has helped a lot.

Thanks

Dan

[Winon]

Glad I could help in some way.

BTW the standard Excel search feature will not be able to handle a multiple search for the part locations or a part number or a description or make etc to find the part. The standard Excel search feature only searches for the "EXACT DATA" that is entered.



Please remember to mark your thread as Solved if you are satisfied with the help received.