Doesn't anyone record a macro to learn anymore?

cjcobra

Board Regular
Joined
Apr 9, 2002
Messages
193
I've read so many posts about people wanting to simply copy and paste something and wanting people to code it for them. What happened to recording a macro, then figuring out the code and editting it to what you want? Guess I learned the hard way, but it just seems people are getting lazy and don't want to even try to code before asking questions? I just saw someone wanted code to print out a couple sheets and that's it. OK, so record it and be done!
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

mas550

New Member
Joined
Jan 4, 2011
Messages
20
i know the feeling. i had to figure out to code at work... just to remedy the "there has got to be an easier way" feeling... i have pages and pages of recorded macros that i learned from. everything from creating new speets nameing the tabs and saving to if(vlookup) and copy paste. i usually spend hours trying before i ask the question, even then i generally figure it out before i get an answer. its nice to know im not the only one that records macros.
 

mas550

New Member
Joined
Jan 4, 2011
Messages
20
but obviously I haven’t learned to type or spell check... lol ... end of the day and my brain is fried
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
20,919
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
Ah yes, but why learn, if you have soemone to do it for you.
Have you also noticed that a simple Google search will answer most of the recording questions ?
Just think though, now that you have gained more knowledge, you can decide which posts to look at or not.

Unfortunately, some people lack both the logic skills to code even the simplest VBA , or the mathematical skills to work out which formulae to use, from first principles.

Further, the poster just might be an old bugger like me, that simply can't get their head around stuff like this.......I'm one of the lucky ones......I have some understanding of what I actually need, and am capable of. So, I share what limited knowledge I have, in order that others may learn....I know it's frustrating sometimes.....but we can always log out !!
 

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,115

ADVERTISEMENT

I guess alot of people don't know that it's even possible to record a macro.

A number of times I've seen posts asking for macro help, and I haven't known exactly what code would work, so I've recorded it myself, and posted back saying something like
"I tried recording a macro, got this, and it seems to work OK...."
which hopefully makes them aware of the possibility of recording.
 

Jon von der Heyden

MrExcel MVP, Moderator
Joined
Apr 6, 2004
Messages
10,810
Office Version
  1. 365
Platform
  1. Windows
I guess alot of people don't know that it's even possible to record a macro.

Point well made Gerald! I did a small course in VB3 before I even touched Excel. I discovered the VBE before I discovered that recording was possible.

Another point is that sometimes the recorder doesn't cut it.

No doubt there are some people that come here that are just looking for the solution. If you take offense to that, and believe (s)he is just being lazy, then of course you are free to just skip past that post. Different people use this forum for different purposes. Some people come here for answers, some people come here to learn. This forum is open for both groups.

Note to anybody that wants to contribute to this thread: This thread can easily go down the route of similar recent threads in the Lounge. By these I refer to the threads that some members posted to referring to specific posts and specific members. Please avoid doing the same here because it is very much against the rules and this thread will quickly be removed and moderators will come down hard on you. What with recent occurrences I thought it would be best to appeal here now. Thanks. :)
 

SuperFerret

Well-known Member
Joined
Mar 2, 2009
Messages
515

ADVERTISEMENT

I do think some people are just being plain lazy, and if I can find the answer using the macro recorder or just by searching this site (I normally do a quick search myself to see if there is definitely an answer) I have advised them. Some listen, some don't.

You gotta take the good with the bad I guess.

The one thing that still gets my goat is people wanting their homework done for them and I have politely made that point to the culprits as well. I'll offer advice, but I ain't doing it for them ;)
 

TinaP

Well-known Member
Joined
Jan 26, 2005
Messages
525
When writing new code, my first step is to try the macro recorder. If that isn't satisfactory, then search for the answer. However, many times I've tried the macro recorder and found either no code was recorded or the recorded code would be incompatible with earlier versions of Excel (sort, anyone).

Rather than condemn the poster, I think we should try to educate them not only in Excel/VBA, but in how to record macros and searching using appropriate keywords. I've had many people on this board politely suggest keyword searches which have lead me to great sites that I wouldn't know about without their suggestions.
 

Rasm

Well-known Member
Joined
Feb 9, 2011
Messages
500
Is there a collection of cool code - somewhere - just to mess around and see how folks do stuff - I like learning. But been using VB in Visual studio 2005 - and this Excel stuff has a lot of Excel specific code.
 

Forum statistics

Threads
1,141,731
Messages
5,708,151
Members
421,549
Latest member
Dtcfire

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top