Converting a button macro

[Juan C]

I have an excel sheet that have a button to place orders in the stock market manually. I need this button to execute every second instead of me pushing it manually.

The present code (manually operated) is as follows:

Sub placeOrder()
Call OrderFunctions.order2(Selection.rows, serverCell, extAttribColumn, True)
End Sub

Can you please tell me how to do this?

Many thanks in advance.

JC

 

[Joe4]

Take a look at using the OnTime method. Chip Pearson did a write-up on it here: http://www.cpearson.com/excel/OnTime.aspx

 

[Juan C]

Dear Joe4:

I appreciate your response, and do agree with you that I should learn how to use macros... But I have a time constrain and need to finish this workbook before month end, thus the reason for looking for help.

My situation is a bit more complicated than what I expressed before.

I have this program that populates on a sheet called "Basic Orders" rows begining at #14. Once these rowns are populated with our program, I have to highlight that row and then press the "Place Order" button in order to execute the order.

So the macro I need have to 1st) locate the last row that was filled, 2) highlight that row, and lastly, execute the "Place Order" button in order to complete the order.

This procedure then repeats once the variables are in place for our program to fill a new row, and once filled, then the macro have to complete the aforementioned steps.

As you can see, this is a bit more than macro 101, thus the reason of my need for help.

I will really appreciate if there is something you can do to aid me here.

Thanks very much for your help.

JC

 

[Joe4]

If you are on a time constraint, and don't have the time to do it yourself (or just don't want to), perhaps MrExcel Consulting Services may be more of what you are looking for: http://www.mrexcel.com/consult.shtml