Forum Discussion
Solved
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.
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?
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?
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.