Highlight Userform Textbox in Excel VBA, Highlight All Text On Mouse Click, Button or Userform Open

[@cptgerard]

Great job. Searched long and hard for this tip. Thanks.

[@ExcelVbaIsFun]

So glad it helped, Captain Gerard!

[@excelisfun]

Thanks, excelvbaisfun!!!!

[@wayneedmondson1065]

Hi Dan.. great tips.. simple.. job done. Thumbs up!

[@KrashNav]

Excellent...Userform Initialize did it for me!

[@ExcelVbaIsFun]

Nice work, Edgar!

[@jossjones3127]

Many Thanks :)

[@andrew_91824]

Howdy Dan, new subscriber and I’m working in excel a lot. I’m trying to create a macro that I can run in one worksheet, and then run it again when I create a new worksheet. Every worksheet I create should have the exact same cell placement, just different numbers to sort

[@krn14242]

Thanks Dan. Good tip

[@ExcelVbaIsFun]

Thanks krn!!

[@anandchaudhari8528]

Sir..need VBA help on this.. ColumnA. ColomnB Company. Products Sale ComA. Pro1 ComA. Pro2 ComA. Pro1 ComB. Pro1 Output Extract unique as per criteria Horizontaly expand if we add more Com and Pro.. ComA. ComB Pro1. Pro1 Pro2

[@SyedMuzammilMahasanShahi]

Good one. Thanks for the tip

[@tshepomoleko6708]

If A1="NA", B1 must return 0 and lock to prevent any value entry. However, if A1="A", B1 must unlock to allow value entry from any of the specified values chosen from a drop down menu. Let's say 0,2,4 and 6 are such specified values. Please help me.

[@Meolimo]

thks Dan ! :-)

[@ExcelVbaIsFun]

Thanks, Mario!!