Click here to Skip to main content
14,937,163 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i have a problem using textbox in visual basic. the problem is i want to find the value in a cell using textbox i have a data in excel the product name and the unit price i created a program using visual basic.
i like to do is if i type the product name in a texbox and i click the find product name button it will appear the data from excel to my textbox including the unit price
Posted

1 solution

Sorry, but do you want to push an excel value into a web page, or get the webpage to pick up an excel value?

They are entirely different questions.

This may help[^] if it is how I think you mean.
   
Comments
a67222 23-Mar-12 22:44pm
   
i didn't use a web page. i created a userform of visual basic from excel.
i want a syntax to find the value of a cell if i search in a txtbox in my userform I have a sample here of my syntax

Dim sStringtofind As String
sStringtoFind=textbox1.text
with worksheets("sheet1")
.range("a:a").find(what:"product name",after:=.range("a1"),lookin:=xlFormulas,_
lookat:=xlpart,searchorder:=xlbyrows,searchdirection:-xlnext,_
matchcase:=false).activate
end with

i hope you can add some more syntax of by your own program

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900