Excel VBA Userform - Dynamic Label Instead of ToolTipText - ExcelVbaIsFun

Hover your mouse over buttons to reveal their description in a custom Label.

Fantastic Developer Tools:

[epca_aq]

Fantastic! It is unlikely that I will ever use a tooltip again...
You clearly have a gift for teaching as well. Very succinct, yet easy to follow. Thank you!

[wayneedmondson]

Hi Dan.. excellent.. very cool tip and pretty easy to set up the way you broke it down into steps. Adds a very professional appearance to the project interface without too much effort.. awesome! Thanks and Thumbs up!

[fitzwarin]

Hi great channel your lessons have been very helpful. is it possible to have 2 different forms in the same workbook that save different data to different sheets. Say for instance the first form was to enter employee details and saves the data too sheet2 and the other form is for entering details of assets and it saves the data to sheet3. So on the home page you would have two buttons one to open each form.

[BayuAdiAnanta]

Good tutorial friend. I have additional techniques to develop my VBA project. Thanks.

[krn]

Thanks Dan. I have used this before and love it. Makes a userform so much more professional. Excited to hear about the new course. I have lots of excel projects I would love to try to convert to .exe. :)

[mikkchannel]

Hi, which Video is, auto Sum when cells value is change, without run macro again????

[WalkerWealthManagementLLC]

Great tip! Thanks for the RetireCode plug!

[vatsalmange]

Can we do it without creating label?
I mean getting the ToolTipText over the button itself while hovering over it.

[misagc]

Q: you mention it runs macro “A Lot” when hovering on non button areas, is there a way to Cause a single text change stopping macro code constant run?

[vikrantpandey]

How to make an exe after this to run it any windows computer and add data in excel sheet

[nehap]

I want to edit link and change connection from VBA

[erol]

Hi,
I am from belgium and have big problems with decimal seperators. Here we use comma instead of dot. But in userform textboxes this give a lot of problems. I get everytime a dot
Examp. 5, 5 + 5, 5 = 11 right!
But when i put numbers in the textbox, with a numpad, it sees as 5.5 + 5.5 = 110
Any ideas how i can solve this please

[kardas]

That intro and transition effects tho - Excel is Exciting! ... ... ... I'll get out now.

[kedarhatkar]

Trying to use this technique on a worksheet with buttons and labels, unable to get the label to go back to default, your help will be appreciated, thank you in advance

[sridharkrishnappanavanerth]

Very nice video sir, I need year help sir, I am working on a inventory project were i have text box for 'ID'. ID is of the format ST-AUG19-0001, I wish to increment the month from AUG to SEP to NOV etc after end of each month and increment year from 19, 20, 21... etc after end of each year and also increment sequence 0001 to 0002....very time i click on transfer button in user form. please explain with a video, this is very urgent for me. Thank you in advance.