Forum Discussion
Populate text in a picture box by referencing a table?
See the attached workbook. It is now a macro-enabled workbook (.xlsm).
You'll have to allow macros when you open it.
To view/edit the code, right-click the sheet tab of the Table sheet and select 'View Code' from the context menu.
See the attached version. Cell A1 on the Farmer and Builder sheets contains a FILTER formula. Its results have been hidden by applying the custom number format ;;;
The first rectangle has formula =A1, the second one =A2 etc.
HansVogelaar That worked great, thank you! I did change the formula to add an IFERROR to the front to eliminate a #CALC! error if nothing was assigned to someone. If I can further complicate it for you, the final step I'm trying to make work is to link the results of your filter formula to another tab. In my New Duty Example, once it populates the text picture boxes, can those boxes be linked to my newly created tabs? For example, on my Farmer tab, when it populates the "Plant" text in the first box, can the first box be linked to my new "Plant" tab? I tried linking the words on my Table tab hoping it would then link the words on the Farmer and Builder tab, but that didn't work. I'm trying to find a way to have it auto link without having to click on each box and manually link it once it is populated. It would be nice if it could make it so the whole box would be linked, not just the text in the box too. If it's not possible, I can just manually link the picture box. Thank you for any insight.
See the attached workbook. It is now a macro-enabled workbook (.xlsm).
You'll have to allow macros when you open it.
To view/edit the code, right-click the sheet tab of the Table sheet and select 'View Code' from the context menu.
- You truly are amazing! I hope I am half this good in the future. Thank you again!
- If I want to use this Macro in another excel file that contains tabs that aren't labeled Farmer and Builder, do I export the macro to my other workbook and change the "Farmer" and "Builder" to what the other tabs are named?