Learning VBA

[mbpress01]

Hi all:

First, and I am sure i speak for a lot of us here, that the experts time plus insights into VBA are very helpful.

On another topic, does anyone have any recommendation to learn "practical" vba. I don't post too often as I am not trying to get free code and would rather take the time to learn VBA myself. But in reality my work requirements don't allow me to focus on coding 8 hrs a day so I post and use code that I can apply in my projects. I have all the standard books but they just don't really give you what you need.

So if anyone can list out or recommend the best way to get up to speed to be an "late beginner / early intermediate" coder, that would really be appreciated. As an aside, here is something I would like to do but can't given my skill level - further I know it can be done.

a) I have a list of 500 names.
b) Depending on the criteria associated with each name, loop through the range and place the name with the matched criteria in another column.
c) The issue is each column is its own criteria and I have 10 ways to match the data.

Solution so far:
a) Loop through the range one criteria at a time and paste the result. Then repeat the exact same code 10 times and change the criteria variable. It worked perfectly, but my lack of skills for arrays prevents me from speeding this up - it takes at least 20 min to do this looping. This is what I mean by practical VBA learning.

Unfortunately, if the answer is just power through it and learn by example then that is what I will have to do.

Thanks in advance for any advice.

 

[Michael M]

without seeing you existing code, there could be many options....
Have you considered using the Select Case method ??
Is screen updating on ??
Is calculation turned to manual ?

 

[hiker95]

On another topic, does anyone have any recommendation to learn "practical" vba.

mbpress01,

See if something, in the below link(s), of my most up to date list will help you:

Training / Books / Sites as of 12/19/2017

https://www.mrexcel.com/forum/excel...e-template-excel-spreadsheet.html#post4972842

 

[hiker95]

mbpress01,

Welcome to the MrExcel forum.

We can not tell where your raw data is located, sheet name, cells, cell formatting, rows, columns, and, we can not tell where the results should be, sheet name, cells, cell formatting, rows, columns.

It would help if we could see your actual raw data workbook/worksheet, and, in another worksheet (manually formatted by you) with what the results should look like.

You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com


If you already have some macro code, then, in order to assist you it would help us if you posted all of your macro code using code tags.

When posting VBA code, please use Code Tags - like this:

[code=rich]

'Paste your code here.

[/code]