Forum Discussion
Populate text in a picture box by referencing a table?
In my attached spreadsheet on the Table tab, I would like to be able to type a responsibility in column B and have it populate the picture boxes on the Farmer and Builder tabs with each duty title li...
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.
The formulas of the rectangles for Additional Duties return values such as UTM (P). There is a sheet UTM but no sheet named UTM (P). So the hyperlinks fail.
I understand now, it works now. Thanks for putting up with all of my questions.
See the modified version of the workbook that I attached earlier.
- If a text picture is blank, is there a way to hide the blank box with another macro and then unhide it and populate the box with text once the other macro criteria is met?
