Okay assuming the name of your text box is SbTt and your check box is Drv1 then
Would another sheet be selected while you do this or would you be looking at the page you're pulling the information from? You could activate the sheet you want to pull the information from when the box is checked...see code. I assumed your sheet was named currency. If not just change the name.
Also my original code populates the text box, not the excel spreadsheet, it just does it on a widescale, as I explained in the post, it's user selected ranges.
Bookmarks