Видео

Awesome!

thank you for your short video

300

It worked like a charm, thanks good man

Why is she doing this?

How do you change the backcolor of the buttons? (Please don’t just say it’s impossible)

I am speechless

Important to note is that if you copy the Function SendMessageA from some places on the internet then there is no ByVal or ByRef on the last argument. If that is the case, then you will need to either add a ByVal on that argument so that you have ByVal lParam As Any or alternatively add a ByVal on the second call of that function so that you have ByVal Biffa$ Otherwise you will likely get a crash Alan

Very helpful to get one going in the right direction, thanks!

We can also do some useful things IN Excel with API, such as navigating down a Pane window’s hierarchy to get to a button and then press it, which can give us a way to do something that their are no other known ways to do in VBA

This is one of the better learn VBA API play lists that I have come across. Unfortunateely it didn’t come up so often in a search, but I am glad I found it eventually. Alan

The API Viewer is a very useful List for Declarations and Constants. It also seesm to have been designed to have an explanation window that pops up when hitting F2. But so far all the explanations seem to be missing. However ApiViewer seems to originate from allapi mentalis - That site has a list, explanations and examples.

Clear

Good news -- I got it running. Bad news -- the antiquated ActiveX Web Browser tool doesn't support modern webpage features, and it gets a lot of scripting errors on most websites.

This works well even in Microsoft 2021 to Increase the number of Undos in Excel - Thanks

I know its a bit late but it was useful and I ve learned a lot!

Very helpful to get one going in the right direction, thanks!

👍

Apparently these aren't fire ants; they would have overwhelmed it had they been fire ants.

he did not take on an ant colony, the colony was dead before he got there, he just pickin off the stragglers

So what was the final conclusion?

Sir please solve my problem I have 2 user form each has 1 text box when I write code for both text box when textchange Msgbox "hi" But when i load 1 user from to another form text chane not work

Can I use low loop count as 20000 take much time? what is the use of loop count? And what is the lowest count of loop count?

Ants

I think lots of people don`t understand how this works (by comments) :P Some solifugid can release chemicals that make ants dazed & confused. There are others who use similar way to mess with ants, myrmarachne and some butterflies from genus Phengaris come to mind. Or to but it simply, camel spider uses chemical warfare to commit war crimes against ants XD

What was the purpose?

i would just like to thank you for this! it even restricts the OLE msgbox. superb! again thank you very much sir Alex!

Another one...for 'the pile'...

Thanks. Solved the problem in office 2016 as well. Great

300

this helped me even in 2024

the war in Ukraine in a nutshell.

抄家滅族

Thanks for sharing!

This is pretty much how Eminem handles everyone on diss tracks 😂😂😂

"To the pile with you"

Texas? I thought they lived in the Kalahari

Wait but is the spider defending his home or attacking a colony ?

This is Sparta

Thanks so much, what a useful tutorial video

I tried to do it If range ("A1")=true then Range("B1")=False Range("C1")=False Endif But I couldn't run it 😢

This is called maths😊

He f’d all Dey ahh upppp lmaoooo King 👑 lmaoooo 🤣😭😭😭😭

The ants are coming at him the same way the villains do in john wick films, just one at a time

This could have been a valuable resource. However, you do not give us a full screen on the declaration of the sndPlaySound function. "Simply write this out" doesn't cut it when the FULL LINE is not on the screen!

Does he eat the ants? Or does he poison them? Or does he grip break them. Or was he just testing his might?

I have never seen a "spider" like this one before. Looks like something from a sci-fi horror story.

"Kill one ant, and you are a murderer. Kill millions of ants, and you are a conqueror. Kill them all, and you are a God. "

Fun fact: Camel spiders don’t even eat ants

Cameraman was feeling them ants after awhile