Hey there! Ok, here's the thing... I have a user form with 5 text boxes and two buttons in the workbook "Files", button 1 saves the values of the textbox in the workbook "Files", button 2 opens a flile "database", copy the values of the texboxes and closes the file... My problem :confused:...Now, I incorporate a new textbox and button. I need, that when I click the button3 the workbook "database" opens and find the value of the new textbox... Then, copy the value of the next cell and show it in a text box... Is that possible? I have mental block right now... :banghead:

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Excel Macro Find a value in another workbook and show a reference in a message box

Thread starter RuthyHermosa
Start date Jan 22, 2014
Tags

excel macro

RuthyHermosa

New Member

Jan 22, 2014

Hey there!

Ok, here's the thing... I have a user form with 5 text boxes and two buttons in the workbook "Files", button 1 saves the values of the textbox in the workbook "Files", button 2 opens a flile "database", copy the values of the texboxes and closes the file...

My problem

...Now, I incorporate a new textbox and button. I need, that when I click the button3 the workbook "database" opens and find the value of the new textbox... Then, copy the value of the next cell and show it in a text box... Is that possible? I have mental block right now...