Відео

How do you link the pop-up to another column that indicates the status of the task? For example, If the task status is completed, I do not want a pop-up for it

Video didn't help in my case but one of the comments did. Lookup table should have alphabetical order.

Thank you you solved my problem

I have a love-hate relationship with VBA. It's frustrating how quickly something can be built. There's no other platform that can go from prototype to finished product and save hours in the business world within literally a few hours. I can't count how many times I've said, 'No, this is the last VBA project I'll ever make. I'll move to MAUI or something web-oriented like Django.' Yet I always end up thinking, 'I'll quickly make a prototype in VBA, and later I can rewrite the app in something more modern.' And years later, the business is still using the VBA program that was made in 3 hours

Great, That worked well, Thank you!

Thanks a lot, this solved my headache!!

Thank you so much for teaching how to check cell references are a match. I spent a whole day trying to figure out why my vlookup was not working until I watched your video. And as soon I applied your check method I knew where the error was - a space that I couldn’t spot!! Thank you.

This video didn't help my specific problem but the solution to the problem I had was that my table array's left most column wasn't the same as my reference value. Hope this helps someone

Solution at 4:00 really helped me. Thank you very much!

I have used vlookup and has worked beautifully, until today doing another project and IT'S not working. It's so weird and absurd the mess. I have a list of cities and counties. Example: Cerritos belongs to LA, column A is Cerritos, column B is Los Angeles the list has 500 cities and counties they belong to and i named the sheet as CitiesCounties, and I have another sheet where I pLace the vlookup example: =xvlookup(L1,CitiesCounties!A2:B500,2,FALSE). So the T1 is where there are the cities, and on the column S I put the formula. So it works partially. It's so weird where there is city Anaheim, it put Orange, but then there are other rows that has Anaheim and the vlookup shows the #N/A. It puzzles me. I even trim/clean the whole column is case there are some stuff there. I don't know why it's not working. I don't what's wrong. If I use the xlookup(new version) would I still have problem?

Thank You!!!

Legend

A little higher volume no ah? thumb down

Wonderful ❤ Did the job brilliantly. Thanks

BRILLIANT! Thanks a lot. I knew it was cell formatting, but didn't know how to fix it. Sigh of relief.. Thanks again.

I love the possibilities VBA offers and I have experienced how powerfull it can be, but why does it have to be such a darn annoying language to programm in???😅

Awesome!!! This helped me so much, a got back an hour of my time🙂

Thanks! Was the formatting issue that was causing me trouble. Appreciate the help

Thank you - your video helped to solve the problem.

Hard to believe there’s only two (now three) likes on this. Thank you, sir.

I'm now using xlookup instead of vlookup. Took me a while to get used to it as I used vlookup for so long, but it is an easier formula to use. One caution is that xlookup is not in some older versions of Excel. I think it was introduced in 2019. It is simply a more flexible and improved version of the vlookup formula. I might also add the TRIM function will remove blank spaces after the lookup_value cell. And, I find the Data Tools/Text to Columns trick works even when the formatting is the same but the #N/A still appears. I usually convert to Text to clear the error then back to General formatting just because. Some things I've given up figuring out why... And, good video!

Lrow = Worksheets("to do").Range("e" & Rows.Count).End(xlUp).Row + 1 the below mention vba code need debunked showing error 9 see below attached reminder table please create code accordingly to this SR NO. PARTY NAME NOTICE DATE OFFICER NAME SECTOR DUE DATE STATUS 1 GHK 21-12-23 RANVIR SINGH 12 25-02-24 OPEN

THANK YOUUUU.

hey great video though I get a "#value" error when using "=GET.CELL(38,Sheet1!A1)" which references a cell with a manual background color. I also tried "39" as well. Any Ideas? The blog referenced will come in handy later as well. Thanks.

The Date > Text to Columns > Text did the trick! Thanks!

I entered the formula in the name manager, but when i apply it in a cell, it goes with an error (#Name?). Please help with this.

great video, very helpful but in my particular case, I'm trying to return the color of a conditionally formatted color. Any ideas on this?

How do you know that yellow is cell colour 38? Where does this number come from? Excellent video - thanks for your help

solved my issue thanks

Thank You

You are amazing! Thank you!

Thank you 🙏🏼 Excellent video

Wow This video was amazing !!!

Thank you, thank you, thank you!!!

Thank you!

Thank you so much for this! Was stuck and couldn’t for the life of me figure out why lol

thanks a lot sir, that helped me a lot.

Thanks sir Works perfectly

This was great! Another tip - if you are getting some text values in a column correct and then suddenly interrupted by #N/A and then again further values are again correct and you are 100% sure that the value in the look up table exists and has a correct format, just sort the look up column values from A-Z.

thank you! I love this and i cant wait to get started learning VBA

Hello sir, maybe you can help me, I made a code but it is too long now I want to reduce it, is this possible? One section has the following code; Application.ScreenUpdating = False If Sheets("Menu").Range("E2") = 1 Then Sheets("toplay1").Select Range("A1").Select5 ActiveCell.Formula2R1C1 = _ "=FILTER('S1'!R[1]C[1]:R[20]C[1],'S1'!R[1]C[1]:R[20]C[1]<>" "")" Range("B1").Select ActiveCell.Formula2R1C1 = _ "=FILTER('S1'!R[1]C[5]:R[20]C[5],'S1'!R[1]C[5]:R[20]C[5]<>" "")" This continues, at (c[ ]) each time 4 is added until 37 is reached Could you help me? Thanks in advance.

Hello sir, I found it interesting but I don't fully understand it, maybe you can help me, I made some code in VBA but it is quite long, I think through different loops it can be shortened. What do I want to do want to work with filters (10 columns and 20 rows, one row in between and then again), this for 2 different worksheets, Can you help me? Thank you in advance;

Hi, is there a way to add time of the day variable for the reminder instead of just a date?

I have been struggling with this issue for the past three hours, thank you for this video!

Have extra what in third product example?

Very helpful!

Very useful. Thanks.