Good day everyone. Where has the year gone!
I've been ripping my code to pieces trying to write this one simple line; however, I can't get my head around it.
I need to pull a value already populated in ComboBox1 from Sheet-B then assign that value to a variable on Sheet-A. I just can't...
aside from the doing this manually each time i either create a list or new sheets is there a formula for what i am trying to accomplish?
i have a workbook with lets say 4 worksheets.
work sheet 1 has my list of the other sheets names so we'll call it index.
Index
sheet-A
sheet-B
sheet-C...
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.