Fill Textboxex with Corresponding Record

[active_x]

example: (refer help8.xls)

//if the hyperlink does not work,
//TYPE(NOT CLICK) this url DIRECTLY IN THE BROWSER :
http://www.geocities.com/remember_it/help8.xls

Action:
type "ctmr1"--> tbxctmr
type "G-528"--> tbxStyle
press "Find"

Question(s):
how to set: when "Find" is pressed, "tbxSize", "tbxColor", "tbxQty",
"tbxPrice" and "tbxAmt" show the corresponding record?

File Attached: http://www.exceltip.com/forum/attachment.php?postid=260709 (help8.xls)

 

[active_x]

Tom Ogilvy,

Really thx for your help!!

I wonder if you would kindly add comments to the vba codes, since I am
not very clear about the flow of the script. ^_^