Using VBA to Parse Variables from 1 to 3 columns

Hello,

This is my first time using VBA in Excel and I'm a little confused where to start.

Here's what I'm trying to do: In my worksheet, there's a column of data that contains "city, state. Synagogue_name". I'm trying to parse out these three values into separate fields using INSTR and MID. So far, I'm just working on INSTR.

I think I've figured out the VBA code to find the first comma:

Please Login or Register  to view this content.

G1 is where I want the value to go, F1 is where the "city, state. Synagogue" data is.

It's at this point that I get lost. I've written this as a module, but how to I activate it? I can't seem to make a macro to point to this VBA script. How would I automate this for the other records (almost 30,000 of them) in this table?

After I figure this out, I plan on using MID to create variables out of the word between the values returned by INSTR, and them somehow get the variable into a new field.

I've only done a bit of VBA in Access before, and that was mostly on events, so this is new stuff for me. Any help is much appreciated!

Thanks!

Nathan

Welcome to the forum.

Please take a few minutes to read the forum rules, and then edit your post to amend the thread title and add code tags to your code.

Thanks.

Thanks for amending your thread title.

Maybe this:

Please Login or Register  to view this content.