Excel VBA Basics #29 How to Use ME in Excel VBA (me dot object variable)

What's up with people using "me" in Excel VBA? In this tutorial, we show how to utilize this built-in variable for several objects and how much of a time saver it is.

Check it out!

Fantastic Developer Tools:

[ExcelVbaIsFun]

I'm so glad to be of assistance. You're very welcome!! Dan

[ExcelVbaIsFun]

Yes sir, Kevin. ADO and DAO are a tiddly bit more complicated forms of VBA, they typically don't have autofill options, so they must be memorized or copy/pasted. They can connect you to Word docs, txt files, other applications, and hidden features to be turned on/off. Adobe pdf files, access, etc. They are trixy and false, but awesome. We'll be addressing these down the road. Thanks KEvin!

[nataliyamyshanych]

Great video and nice explanation!!! Thank you Dan

[ExcelVbaIsFun]

Yes, its on the agenda. Kind of a broad subject (aren't they all though). Any specific questions/projects? Thanks Giorgi!

[SotirisKD]

Very helpful tutorials. Thank you so much!!!

[timopheim]

One note to the viewers. Around 8:20, Daniel poses the question of what to do should you have to rename your form? Though me. saves time, there is another fix which Daniel mentions in an earlier video. Simply press ctrl+f and mark the box that says replace with. Enter for the find value your old user form name and for replace, your new form name. Then the program will take care of the rest

[AkshayKumar-zbou]

Hey Dan, I am new to use VBA. I have an excel workbook with multiple sheets and i want to follow the same command to all the sheets.

For example: I Need A43= Blah in Sheet1 to Sheet5. so I am following the below:

Sub blah()

Sheets("Sheet1").Select
Range("A43") = "Blah"
Rows("25:70").Select
Selection.EntireRow.Hidden = True

Sheets("Sheet2").Select
Range("A43") = "Blah"
Rows("25:70").Select
Selection.EntireRow.Hidden = True

Sheets("Sheet3").Select
Range("A43") = "Blah"
Rows("25:70").Select
Selection.EntireRow.Hidden = True

Sheets("Sheet4").Select
Range("A43") = "Blah"
Rows("25:70").Select
Selection.EntireRow.Hidden = True

Sheets("Sheet5").Select
Range("A43") = "Blah"
Rows("25:70").Select
Selection.EntireRow.Hidden = True

End Sub

Can you please guide a better way to follow the procedure.
Also i am facing a problem that whenever I change sheet name, I have to make the same changes in my VBA Module. Is there any way that it can change automatically in VBA.

[giorgikavtaradze]

hello Dan, thanks for all of your videos, its verrryyy helpful,

can u make some about connections? DAO, ADO ..

[guitarwinds]

Cool video. I don't use forms much yet but if I do I'll have to get the ME function on in it.  Very useful stuff.

[ExcelVbaIsFun]

Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan

[ExcelVbaIsFun]

RicksGAFaves, lemme see after work today, maybe i put this in the wrong category. I'll see if this belongs in tips and tricks. Thanks so much for your input. Dan

[giorgikavtaradze]

nothing specific, just want to learn more :) thanks again

[vincenttran]

Hi Dan, Where are Excel VBA Basics #27 and #28, thank you so much guy.

[JaroslavNedved]

Hey Dan, your videos are awesome and they're really saving my ass! Thanks a lot ;-)

[krn]

Sounds like I could use that also since I don't know what DAO is. Lol.

[ExcelVbaIsFun]

Free outros at splasheo.com, hamy! Check it out! thanks, dan

[denswin]

I didn't like the way you kept jumping around all the time.  Please stick to one type of form as I am trying to learn this. A beginner can't keep up with the fly-bys.  I enjoy most of the videos but please don't make it more complicated for us.