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 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?
