I've just started teaching myself VBA code for some forms I'm creating in Excel. For the pros in the bowl, how'd you learn and what are some of your favorite use cases?

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

In my opinion, learning VBA is great but both VBA and UserForms in excel are soon going to be deprecated.
Might be more useful to start learning powerapps.

In any case, youtube videos is a great source to know the art of possible. Couple it with chatgpt for your needs. Keep reiterating till you are happy with the end result (UI/UX, end result, speed of form/performance, error handling)

like

If you need to move quickly, SharePoint lists are easy to learn and work well with power automate. This accomplishes most form related needs.

VBA is somewhat of a useless skill these days (sadly). Macro enabled workbooks are blocked by almost all corporate email policies. It makes sharing your magical workbook really difficult. Figuring out how to get the same functionality without using a macro is the real skill

like

I would suppprt learning the power platform, as well, the combination of PowerAutomate & PowerApp are unmatched and WAY UNDER UTILIZED

like

I learned VBA from a book in the 1990’s out of necessity to build an optimization tool.

I agree that newer tools and languages are better to learn now. And with AI learning new skills is easier than ever

Related Posts

How much an application development team lead gets @ accenture YOE 6 ?

like

Guys what is this impact training and bonus at citiustech
I was not offered this impact thing in my offer letter is it only for freshers ?

like

Can anyone invest in Roth IRA asking with 401k or is there a limit based on salary? I was told if you are making above X, you can't invest in Roth IRA. If this is true what's is X amount?

like

Hi Fishes,

If anyone is looking to buy Life/Health insurance product please connect, we can avail good deals and discounts.

like
like

For those that take on small freelance projects on the side (more consulting/work for small companies, night/weekend hours), is it worth setting up an LLC for that? Do you typically lower your rate for small companies vs what it would be freelancing at a day rate for an agency?

like

Received offers from PNC and UBS. Same position. Same benefits. Purely seeking opinions on the companies. Previous experience at EJ. Left to get away from outside sales nature and isolation.

likehelpful

Currently looking to relocate to Netherlands / specifically Amsterdam; can anyone share some insights to average Senior Manager salaries? TIA

like

Anyone with insight on Tenzing Private Equity? Everything notable is appreciated!

I just came back from a UIL academics conference. It always makes my head spin. So much packed into two days! Loved it but wow! Best part: seeing college professors who really care about the subjects!

Are there any Exploring Computer Science cohorts in New England this summer?

like
like
likehelpful

Times are changing (thankfully)!! Many of us are witnessing growing pains amongst our mid level management. What,if any are you or your company doing to help streamline leadership? Also what kind of pushback are you experiencing?

like

Been riding my bike recently and am getting grief from those close to me that I need to wear a helmet . M here — any suggestions ?

like

When will google hiring resume?

like

Hi everyone,
I’m hiring for x3 Sr / Jr Application Security Engineers in my team.
UK based, team is 100% remote, although the office in London is there if you prefer.
Pre IPO unicorn valued FinTech startup.
Get in touch for more info 🙂

like
like

How many days can we expect to get any confirmation on the offer ? My HR round is done and salary discussion is also done but after that nothing from their side..

like

Looking for SC and Managers to join the Financial Crime team at FTI, DM if interested.

likehelpful

Additional Posts in Excel Genius

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

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

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

like

Everyone: Excel is a smart app
Excel:

Post Photo
likefunny

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

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

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

Would anyone be willing to teach me vlookup?

like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

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

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
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