Excel VBA search facility

By stefan.oldroyd ·
Hi guys

I'm using VBA in excel to find a particular product.

At the minute I have it working by searching text string in a textbox control and the macor finds the product after you hit a "search" button.

Ideally I'd like to be able to further automate this so that that it would search automatically after you select "enter" (carriage return) on the keyboard in the textbox

Can this be done?

Any help much appreciated


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

So Easy

by fakemail In reply to Excel VBA search facility

It is so amazingly easy you wont believe it.
Under the properties in the VBA editor for the search button simply set the default property to True. Thats it. Done.

Collapse -

help please

by joseroque In reply to Excel VBA search facility

Hi stefan,

i have a problem with an excel form, which could be solved by exactly the macro you described in your post. however i know nothing of programming, do you think you could pass that macro on to me? even better would be if you could send me the excel file, without data of course, to me at

hope i'm not imposing to much, but i'm really out of options.

thanks in advance

jose roque

Related Discussions

Related Forums