What are the best resources for learning to write VBA macros for Excel? I’ve watched so many videos that teach the basics and then it feels like it jumps to super complex…

like
Posting as :
works at
You are currently posting as works at

Honestly you might be better off learning power query at this point depending on what you’re trying to do. I learned VBA mostly just by trial and error

like

I used chatgpt + google/forums to teach myself, no kidding

I tried using ChatGPT also, but I could only get it to help with really basic commands. The challenge has been figuring out what order the commands need to be written so the code doesn’t break. Recording the macros has really been the easiest solution so far, but I only know so much and need some more advanced help.

If you set the stage for chatGPT, as in explaining the function of the sheet and then asking it to create code, it works much better. I have learned a ton from this especially as I am needing to repeat similar code

Related Posts

trying to make a move into FDD...any insight into how i should prepare, know, gain skills etc. for interview and networking!

like

Hello wonderful community, I have recently relocated back from Canada with 6 years of experience in the non-profit space within marketing/resource mobilization. I’m based in Gurgaon and wondering what the best way to go about the job market here. I’d love to explore some MNCs, open to wfh as well.

like

Such an amazing experience seeing my plants grow! Propagation was a SUCCESS!!

Post Photo
like

Ritz Carlton Chicago anyone?

like

I have a case I have enough evidence on to go to summery judgement on off the gate. Procedurally what's the best way to go a out this? D's are unrepresented and extremely difficult about settlement talks.

like

Hi Fishes,

As iam working in warehouse and logistics with 3 years experience, iam planning to switch to IT so iam doing SAP MM Course any advice regarding this

like

Ex-consultant now in marketing. Used to be an avid follower here and got great insights on companies when trying to exit consulting so thought I’d try here for advice. Outside of FAANG, what are good large CA-based tech companies that provide good pay, WLB, and culture? DD has great people and WLB, but pay is low and you’re not given the tools and resources to succeed + truly make an impact. Google and Apple are ideal but need backups. Like is Salesforce still good? A company along those lines.

like

Hi Guys,

Please help me with relevant interview questions for bizops engineer in master Card

like

Does anyone work for Capgemini invent? Got a call from a recruiter but looking for more details

like

Hey UK agency folks, Is it normal to expect a very experienced, award-winning illustrator with an extensive online portfolio to make pieces "on spec" to win a paying job?

like

Do you think diversity training actually works? I can't tell if it's just a way to tick a liability box or if it's actually effective.

like

Really liking the new UI. Great job, FB design team. Wish we had you for our new T&M platform

like

Who are your favorite advertising comedy directors? Who are your favorite comedy directors who are women?

like

Anyone ever stayed at Westin Tokyo? Is the concierge lounge any good?

like

What other cards to add to my collection? I have AmEx Platinum and Chase Sapphire Reserve. Fly Delta so AmEx is handy for lounges. Use Sapphire for dining/travel. Should I add Chase Freedom Unlimited?

like

Anyone in the Bay Area? M here

like

What’s your top nutritional food item that doesn’t get enough love? Trying to change my daily snacking.

like

X moving retty sharply lower. Time for calls?

like

Best paid CPE subscriptions? I know there are free courses on various sites, but my new company is willing to pay for a yearly subscription. Wondering if any paid ones have good courses. Only heard of becker and illumeo so far.

Looking for financial modeling/analysis and data analytics type stuff since I work in finance operations (within FP&A) now.

like

The accuracy 😂😅

Post Photo
likefunny

Additional Posts in Excel Genius

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

like

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

Still don't have xlookup. #fomo

like

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
like

Any book recommendations on excel modeling for real world business applications?

like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Would anyone be willing to teach me vlookup?

like

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like

How do you fix microsoft excel cannot paste data error?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal