ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Fill Textboxex with Corresponding Record (https://www.excelbanter.com/excel-programming/277016-fill-textboxex-corresponding-record.html)

active_x[_6_]

Fill Textboxex with Corresponding Record
 
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/


active_x[_7_]

Fill Textboxex with Corresponding Record
 
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/



All times are GMT +1. The time now is 03:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com