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

RuthyHermosa

New Member
Joined
Jan 22, 2014
Messages
3
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... :oops:
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Watch MrExcel Video

Forum statistics

Threads
1,122,915
Messages
5,598,850
Members
414,263
Latest member
sherrcha

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top