Need help in small command button Project!!

[tv9_rohith]

I want to do a small project with 2 sheets in the same excel sheet, it can be done using Vlookup in excel but I want to make a document very people can just input the value in the textbox1 and click on command button and related information should display in the 2 textbox which will be pulled from the Sheet2( which will be hidden ).

I have an example below but I have more data than this :

In the First sheet I am planning to place a 2 text boxes and one command button.

1 text box is to input the data

2 Text box is for output

and the command button has to be placed in sheet 1 to rerive data from sheet2 cells.

--

In sheet 2

in 1st column I will give site name's like

Yahoo
Google
Wikipedia
youtube

and in the second column I will the site URL's like

Yahoo.com
Google.com
Wikipedia.com
youtube.com


and when i input data - "Yahoo" in 1 Text Box ( sheet 1 ) and then click on Command button it should retrive me value from sheet2 Column 2.( i.e., Yahoo.com ) and the output should display in 2 Textbox which is there in sheet 1.

Please help me I dont know not getting any idea how to do this..

and kindly note that I will not be able to place combo boxes in this sheet since the lookup data is big.

 

[bensonsearch]

any more details with the error?

try

thisworkbook.sheets("Sheet1").textbox1.text = ""
thisworkbook.sheets("Sheet1").textbox2.text = ""

or go back to the properties menu and put the text as " " (just a space the space bar) see if thatworks instead of the above first

 

[tv9_rohith]

and even Im not getting the message box.

Please Please verify and do the needful

 

[bensonsearch]

what are you typing to try and get the message box? it will only fail if Google or Yahoo or anything like that does not exsist, eg if you type in dfgsdf and search for it.

 

[tv9_rohith]

if I try to type yahoo or google then Im gettng the desired value in Text box 2.

But suppose if I type my name in the Text box 1 - I.e., Rohith then Im not getting the msg box instead Im getting the error.

Run Type Erro "13"

type mismatch

END DEBUG HELP

 

[tv9_rohith]

and also regarding Tetx Box 2 even after changing the value in LOCKED to TRUE Im able to enter the characters in the texbox.

 

[bensonsearch]

that is strange indeed, purhaps try putting the msgbox before the exit sub line see if that helps

otherwise id need the workbook to have a look (can upload to free filesharing site and ill download from there).

with the locked, the worksheet also has to be locked as far as I know. otherwise nothing will happen

 

[tv9_rohith]

I have uploaded it here : -

http://www.4shared.com/file/DueOj6ax/Welldefinedproject.html

Thank you.

Regards,
Rohith M

 

[tv9_rohith]

/DueOj6ax/Welldefinedproject
this path is showing up as ... in my message.

http://www.4shared.com/file u put the above one and at last.html

 

[bensonsearch]

Hi,
I tried downloading twice but it says the file is corrupt

 

[tv9_rohith]

I have uploaded here : -
http://www.filefactory.com/file/cd72b1d/n/Welldefinedproject.xlsm

could you please check now.

Thank you