Auto call a procedure by selecting from a dropdown list

Hello Jay3,

Welcome to the Forum!

Are the names of the macros in this list?

Sincerely,
Leith Ross

Hi,

They can be as I'm building something from scratch!

Basically it's a journal for posting accounting entries, and what I want to do is record serverl basic "Copy and Paste" macros, which will run once the relevant selection is made from the drop down.

So Yes would be the answer!

Thanks for replying to my thread

Hello Jay3,

Add this macro to the worksheet with your validation list. Be sure to change the the cell address in the macro to the cell address of your validation list. Remeber Macro names can't have spaces. If you want to use spaces in the list for better readability, let me know and I'll show you to work around this.

Please Login or Register  to view this content.

How to Save a Worksheet Event Macro
1. Copy the macro using CTRL+C keys.
2. Open your Workbook and Right Click on the Worksheet's Name Tab for the Worksheet the macro will run on.
3. Left Click on View Code in the pop up menu.
4. Paste the macro code using CTRL+V
5. Make any custom changes to the macro if needed at this time.
6. Save the macro in your Workbook using CTRL+S

Sincerely,
Leith Ross

Thanks for that, somethings happening now.

Can you tell me where I need to paste the following code so that your procedure knows where to look for mine?

This is the procedure I need to call:

Please Login or Register  to view this content.

Hello Jay3,

Are you using this to create the list for the Validation Drop Down? Do you have macros already created called: CALL, FREEXP, and VATCON? Which cell do plan to use for the Validation List?

Sincerely,
Leith Ross

Hi

I've got it to work...thanks!

Basically from the drop down list I'll select an the macro "INVOICE" and it will paste the the corresponding ledger names into the journal, just leaving it to the person creating the journal to type in the amount of the invoice, reducing the amount of typing.

If that makes sense?

I've got it to work now, so thanks for your help, you've been great.

I posted another thread before re conditional formatting using macros, but no one has responded will you be able to help with that one?

Thanks!:D

Hello Jay3,

Excellent work! I'll mark this post solved for you.

Sincerely,
Leith Ross