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.
Yes, indeed.
Make sure that you copy the code to the module belonging to the Table sheet (or its equivalent in that workbook).
HansVogelaar Here is a stripped-down version of the file I tried to copy the code to. I'm getting a "Reference isn't valid" error on my Template Tab "Additional Duties" column of boxes when I try to click the box to link me to the corresponding tab. Instead of putting you original Filter function in the A1 cell and hiding the function, I moved it to my Drop Down tab instead. Is this where I'm messing up?
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?
- I understand now, it works now. Thanks for putting up with all of my questions.
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.