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/attach...?postid=260709 (help8.xls)

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

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. ^_^


:)



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/