I want to either enlarge the font of the selections in the data validation drop down or zoom in on it. I have been given this link http://www.contextures.com/xlDataVal08.html#Larger but I can't get the macros to work. To save a click i'll include the three macros here. I've tried #1 and #2. Nothing happens on my end.
Please Login or Register to view this content.Please Login or Register to view this content.Please Login or Register to view this content.
1 and 2 worked for me...did you place the code in the sheet that you want it to run in?
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
I think so. I just opened the book back up, making it the only one open and still.
A1 is the data validation in my attachment that should zoom. Then of course A2 as in the macro.
taylorsm-macro-that-zooms-upon-select-cell-not-working-book1.xlsm
Nope, you had it in a Module.
Copy the code you have
Double click Sheet1 on the list above the Module list
Paste the code into the blank window on the right
See attached...
Last edited by gmr4evr1; 11-03-2016 at 06:33 PM. Reason: Added attachment
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks