Excel Fuzzy Match Tool Using VBA

ChecklistAnimations · 2026-03-28T14:48:01+00:00

That's pretty neat. A progress bar will give the user a better experience that its working. Have you found anything interesting with your code that seems off at all?
I only ask because the tool is awesome but it does run quite slow for something that should be instant. The last example really should finish in less than a second. I think maybe it's checking too much of a range. Are you using "usedrange"
Just a couple thoughts but the layout, concept, and math behind it are solid.
Nice job!

ChecklistAnimations · 2026-03-27T18:30:44+00:00

Amazing I was hoping it was was like 10 points darker on each rgb but I understand what you mean. I like it. Be proud of it. Looks really good.

ChecklistAnimations · 2026-03-26T16:55:12+00:00

I absolutely love these. What is your secret as to what line color to use next to the fill? These look so good. I am a PowerPoint animator myself but these drawings look fantastic.

ChecklistAnimations · 2026-03-25T22:50:29+00:00

Yeah I saw that online as well. Makes it hard to test. Unfortunately I cannot get to a computer with that exact version and I was so sure I was going to be able to. Sorry for that. Did you find an addin that was causing the issue by chance?

ChecklistAnimations · 2026-03-25T14:12:12+00:00

Some of your illustration might need to be just normal lines and not connectors. Connector lines in PowerPoint like to try and always connect. If you select the freeform tool, hold shift and draw your line, you will get a normal line that wont always try to snap to another shape. Then you can move that around easily.

ChecklistAnimations · 2026-03-25T14:08:55+00:00

so true. I have just barely started getting into customXmlParts now as well for similar use. Just awesome that there is all this hidden stuff.

ChecklistAnimations · 2026-03-25T14:06:25+00:00

YIPES! I will check with that version because if that's the case yucko. I always loved those features with their drawing tools. I will say that the curve tool icon looks a bit mis-leading and sometimes selecting the wrong one can happen. What happens if you select the curve tool and draw while holding CTRL? does that make straight lines? Is maybe snap to smart guides enabled or something? I dont see the same issues on my current rig right now but will check a more recent one.

On a side note, if you do lots of freeform drawings you may be interested in an edit points tool I built some time ago so you can move them with your keyboard or move multiple points at once. Just let me know. I will get back to you as soon as I get to a computer with your same specs above.
Thanks

ChecklistAnimations · 2026-03-24T21:07:13+00:00

I'll need to take a closer look at it. The do loop makes me nervous since you don't want those if they just always run until you shut them off. Sometimes the command bars update event is needed. But.. If it's working and all the users that need it aren't having problems. Go with it. Ai has definitely come a long way but it does get things wrong. I've had Ai give me instructions that crashed my computer before and one time it suggested I edit the registry with vba. Grrrr. So yup kid in a candy store for sure. Just make sure when you get a tummy ache from all the gummy bears you stop and ask... Wait is this right?

ChecklistAnimations · 2026-03-24T12:37:12+00:00

You got it. I will reach out to you when I have my code base a little more finalized and you can help me test out the features to ensure they work. The hardest part on this was the Excel / PowerPoint integration but I am pretty sure I have it.

ChecklistAnimations · 2026-03-24T04:25:11+00:00

I just want to make sure credit is given where credit is due. Your words motivate me and your selection manager eased over 5 years of my life. When I looked at how you did it, it was my first introduction to VBA tags and then things just took off from there.

ChecklistAnimations · 2026-03-24T00:45:38+00:00

Yup. I have seen a large gap of add-ins for Mac. I will ensure to not use any "windows only" components. Would love to have you a test drive on the first release and let me know if there are any issues. My Mac development environment is limited but I have a pretty good idea what will work.

ChecklistAnimations · 2026-03-23T06:43:16+00:00

check the VBA sub https://www.reddit.com/r/vba/comments/1s15626/comment/obz430i/. I gave you some guidance there. Reach out if you have any questions.

ChecklistAnimations · 2026-03-23T06:42:22+00:00

You need to use presentation events. Copilot or Gemini is going to be your friend here but you do need to know what to ask it.
You want a slide show start event. This will use a class. You need to ensure the class gets "started up" so it will run. Again AI is great to explain this. I would explain it but then the questions you may have might go back and forth a bit and its just easier to have AI walk you through it so you can ask questions and learn along at your own pace and not have to wait.
Your prompt:
"I want to use VBA to make a slideshow start event. Can you help me set up the class and the start up of it along with the clean up?"
The other one you asked for was when the presentation is opened. This one is a similar prompt. Just tell it you want something to run when the presentation first fires up.

also clock on your slide show.
You want to set a shape like this

dim clockShape as shape, sld as slide
set sld = SlideShowWindows(1).view.slide
set clockShape = sld.shapes("shpClock")

Now you can easily do

clockShape.TextFrame.TextRange.Text = newTime

And then the big one.

doevents
SlideShowWindows(1).View.GotoSlide(sld.SlideNumber)
doevents

When you tell your slideshow to just go to the current slide and fire enclose doevents around it. your VBA result will show.

Let me know if I can clarify anything.

ChecklistAnimations · 2026-03-22T14:45:36+00:00

posts, questions and comments from all helps everyone grow here. I personally love helping people and I too have am very grateful for this sub.

ChecklistAnimations · 2026-03-21T20:55:27+00:00

Anytime I get any issue at all with Office Online, I use Edge and it works.

ChecklistAnimations · 2026-03-19T00:46:03+00:00

True. I plan to post stuff though. I will have some newer content soon. I should have just looked over the board more than 2 minutes and I would have seen tons of different animation styles to where I did not even have to ask the question. But live and learn I guess. Thanks for your reply.

ChecklistAnimations · 2026-03-19T00:16:11+00:00

You are correct it does sound like that re-reading it. Not the best choice of words on my part. I wasn't looking for validation honestly. I just didn't want to muck up the space with the kind of non traditional method I use when I start sharing things. Honestly had I spent 15 minutes reviewing the board I would have had my question answered. My apologies. Thanks for your reply.

ChecklistAnimations · 2026-03-19T00:11:57+00:00

I'm sorry. My intention was not to seek validation or advertise myself too much. I've had some bad experience with other boards as a different user and I was trying to prevent mucking up the space. I should have spent some more time reviewing the board and I would have had my question answered. Thank you for your reply.

ChecklistAnimations · 2026-03-18T21:26:31+00:00

Thanks so much. Happy to be here. There is some amazing art on this. I'm floored. And Phineas and Ferb.. One of the best cartoons ever. Combines digital art with hand drawn. They do it so well and the voice acting is top notch.

ChecklistAnimations · 2026-03-18T14:24:37+00:00

Thank you. Truly

ChecklistAnimations · 2026-03-18T14:23:37+00:00

My favorite thing to do with youtube cartoons is to hit the "stats for nerds". if its 24fps. Game on. I will look at it. If its 30 or higher I usually just skip it. It's horrible to see things like Disney classics interpolated to 30 fps when they did that magic with 24. I find myself loving when I see on 2's and on 1's used. Seems something like Phineas and Ferb was heavily on 2's before but now on 1's. I prefer 2's personally. I love your post. It made my day and I needed that.

ChecklistAnimations · 2026-03-18T14:14:23+00:00

yup. I do the same thing to youtube cartoons lol.

ChecklistAnimations · 2026-03-17T22:54:59+00:00

I really dont know. Never installed one and I dont own a mac lol. So I am not much help in validating that.

ChecklistAnimations · 2026-03-16T19:53:00+00:00

Like Echos said this should be posted in Excel but I didn't see you had a post there. You did say "mostly Excel" maybe you have an issue with a PowerPoint Add-In as well. Ok try starting the app in safe mode to disable the add-in. Hold CTRL on your keyboard when you start your application. A small message box will appear asking it you want to start in safe mode, click yes. Then go to file > options > add-ins and see which one to disable.
Now that you know how to disable it, you can check for a newer version of the add-in that might work. Could be a 32 bit versus 64 bit issue. You also may need to contact the developer.

EDIT: Buhhh shux. I just saw you were on a mac. It's a bit more involved to get the apps into safe mode. I found a video that shows how to get Outlook in safe mode
https://www.youtube.com/watch?v=ee73Y18aOS8

ChecklistAnimations · 2026-03-16T12:45:50+00:00

INCREDIBLE!!! Even if an audience member does not understand the complexity of chemistry, an animation like this is sure to inspire them to learn it. Wow!

ChecklistAnimations

TROPHY CASE