Label1 active/displaying for 2 seconds only and disappeared

Hi All,

I tried many times with some reference from the excelforum but still stuck.
I didn't put any codes on the reference file.
The "Label1" (properties: visible = false) needs to displaying/active for two seconds only when the mouse is crossing on the "Label1", then disappeared if the mouse is leaving from "Label1".

Thank you good people for any helps.

Iqballhud

See if this helps:

Add the red bits to your module

Please Login or Register  to view this content.

Add this to your userform

Please Login or Register  to view this content.

Marks, thank you for the codes.
When I added another label, with added the codes, it's working only for Label1 shown, not for others.
The codes modified as below,

in Module

Please Login or Register  to view this content.

The code in UserForm

Please Login or Register  to view this content.

The next, I will use multiple Label to be shown for two seconds.
Thank you in advance, Marks.

Maybe you could reuse Label1

Please Login or Register  to view this content.

Hi Marks,

Thank you so much, the codes is working fine and I will mark as SOLVED and STAR reputation will be added.

Another thing, I don't understand about the function of "LabelxZorder(0)", because when i removed, the codes still working good.

Iqballhud

You're welcome and thanks for the feedback.

The zOrder is how the controls are layered. It was just a precaution. By setting it to zero, it makes sure it's on top of the other controls.
You can set this in the VB Editor at design time under the menu Format-->Order-->Bring to Front

Thank you so much, Marks, for the explanation.
wishing you all the best.
Cheers,
Iqballhud