Use the recorder to query a cell and run another macro?

I dont know how to program VB so I just use the macro recorder. I have 15 macros recorded and I need a way to use macro recorder to query a cell and run the corresponding macro assigned to that value (1-15). So if the cell it querys has a 3 in it, it would run macro "three" and then automatically query the next highlighted cell (the cell the previous macro ended on) and so on. Not sure if it can be done, but if it can, itll save me hours.

Thanx guys.

Ya, like I said, I dont know how to do any VB coding. I need something I can either use the recorder in, or a drag and drop VB code that I can just paste into VB.

Thanx for the help.

Ya, I couldnt figure out how to use that tutorial. I tried just adapting that code to my spreadsheet, but I couldnt get it to work. Can you add some comments into that code so I know what I should change to get it to work?
Also, my macros are all saved in my personal workbook, and it didnt seem like I could reference them in the VB code like you did (macro1). I tried Personal.xls!One but that didnt work (it didnt like the "!")

Thanx so much for your help.

Can someone please help me out? I need some VBA coding that will do the following:

Query the starting cell's value (1-30) and run a corresponding macro (1-30) and then repeat for the cell the previous macro ended on. Each macro resets the active cell to the beggining cell of the next data set.

Ive got over a million data entries I need to do this to, so a macro would really help. I dont know anything about macro coding (the 30 macros were recorded) so some comments in the coding about what I would need to change to get it to run on my data and with my macros would be great.

Thank you so much in advance for your help. This forum is awesome.


-Jason