Home Creators Posts Import Register Favorites Logout

Content

Hello Members,

The training we have for this week that I have shared with you was about the Amazing 1-Click Quick View. If you have not seen it yet, you can view it right here on YouTube.

Now that the training has been released, I am looking for your feedback to make this even better, just for you, our incredible Patreon Members.

So, what Feature can I add for you? Did you find an issue you want me to fix? Or is there a particular area you would like me to focus on?

Please comment your ideas and feedback to any of these below and I will do my best to not only create an updated workbook but release a private training video next Monday, right here on Patreon.

I am looking forward to hearing from you and thanks so much for your support.

Regards, Randy

Files

How To Create A 1-Click Record Quick View Pop-Up For Any Table In Excel [FREE DOWNLOAD]

📢JOIN US ON PATREON FOR UNRELEASED TRAININGS + MORE ► https://bit.ly/PatreonDesc 👉JOIN MY MENTORSHIP PROGRAM - START NOW FOR $7► https://bit.ly/7Promo_YTDesc 🔥 GET 200 OF MY BEST TEMPLATES HERE► https://bit.ly/MyBestWorkbooks 👨‍💼JOIN MY INCREDIBLE DASHBOARD MASTERCLASS HERE► http://bit.ly/Dashboard_YTDesc In this week’s training, I will show you how to create a 1-click Record Quick View Popup for any table with a single macro in Excel. ⬇DOWNLOAD THIS WEEKS WORKBOOK FREE: 📩 USING YOUR EMAIL: http://bit.ly/QuickView_WkbkDl 💬 FACEBOOK MESSENGER: http://bit.ly/QuickView_FbDld EXCEL COURSES: ►DASHBOARD MASTERCLASS: http://bit.ly/Dashboard_YTDesc ►MENTORSHIP PROGRAM: http://bit.ly/MentorProgram_YTDesc ►BEGINNERS VBA COURSE: https://bit.ly/FreeVBACourse EXCEL PRODUCTS: ►The Ultimate Excel Resource Guide: http://bit.ly/UERG_YTDesc ►200 Excel Workbooks: https://bit.ly/MyBestWorkbooks ►Convert Excel Into A Secure EXE File: http://bit.ly/SecureExcel ►Automate Your VBA Programming: https://bit.ly/AutoMacroAddIn ►Create Dashboards & Charts in Seconds: https://bit.ly/Pine-Bi ►Find the Best Excel Products & Courses Here: http://bit.ly/ExcelProducts JOIN OUR COMMUNITY: ►Facebook Group: http://bit.ly/groupexcel ►Facebook Fan Page: https://bit.ly/EFF_FanPage Follow me on my Social Media Accounts: 🐦Twitter: https://twitter.com/Excel4Freelance 🌏Website: https://www.ExcelForFreelancers.com 🔗LinkedIn: https://www.linkedin.com/in/excelforfreelancers/ 👤Facebook: https://www.facebook.com/ExcelForFreelancers/ 📸 Instagram: https://www.instagram.com/excelforfreelancers/ 🎥Rumble: https://rumble.com/c/ExcelForFreelancers 👤Locals: https://locals.com/member/ExcelFreelancers ✉Telegram: https://t.me/ExcelForFreelancers 📲Gab: https://gab.com/ExcelForFreelancers About Us: I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money. I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep these training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams. Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here: 👉 https://www.youtube.com/c/ExcelForFreelancers/ New Training Video Uploaded every Tuesday! Thank you very much for your continued support, Randy Austin

Comments

Martin Koss

Hi Randy. As per our previous message exchange, I would love to modify this to something that doesn't have the quick view when the user clicks anywhere on a row, but, rather, have a field or shape on the end of a row (ie the last cell, perhaps) and when they click that then the quick view pops up. That way the user can, be default, look at the sheet in the normal way and only when they need to they'd be able to click the Quick View cell / shape / button. Hope that makes sense. Martin

Excel For Freelancers

HI Martin, its a great idea and I will be adding it into the Feature, Fix or Focus update on this. Much appreciated

Benjamin Oettel

Hallo Randy, I haven't watched the whole tutorial till now, but what come up to my mind is the question in how fare it is possible to give cells with a date a certain background colour pending on the condition (green, yellow, red pending on the condition of how "old" the date is (green = okay, yellow = e.g. 14 days before expiring, red = expired))

Excel For Freelancers

HI Benjamin it is certainly possible using a date-based conditional formatting along with the Today formula such as If (Today()-A1>15,True,False) You can then add additional colors based on different #'s and rules. Thanks for the great question