Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Description Pop-up Windows

0

Hi, I want to know if that possible to make appear a Pop-up windows with the description inside of a specific data. what I need is, from a cell we look for a data, exemple: VLOOKUP(MAX( etc.. that bring the answser CE11. from that Answer CE11, I want a Pop-up Windows open with the Description of that CE11 error code. so I need 2 thing, 1 how to make the Pop-up not in Macro if possible, 2 how to enter the formula into that box to show the description. hope that clear enough to understand

thank you

excel
MS Office Version: 2013
posted by: Natas20075 on Tue Jul 30, 2019 at 9:22 am
Answer
Discuss

Discussion

You won't be able to do a pop-up window without a macro in this case. Also, where would you get the information to display for the error code? What you could do is to use a cell next to the current cell that will display the error code information and that cell will simply have a vlookup() that references a table on another worksheet. If you format this correctly, it should look quite nice, or use an ActiveX textbox maybe - but I think a popup window is out of the question unless you want to use vba. Either way, the error code data will also need a table in which it resides somewhere in your workbook.
don (rep: 1989) Jul 30, '19 at 2:02 pm
Thank you Very much for taking the time to answer my question, I was assuming this will not be possible without VBA but has I begin with Excel I don't know it vey well. This is what I do right now, I call the description with another VLOOKUP option ^/^ just more attractive with a Pop-up Windows.I will try the ActiveX Textbox, maybe I can make something similar to what I want
thank you again
Natas20075 Jul 31, '19 at 6:57 am
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login