macro uploaded, but how do I use it?

Hello,

I have this spreadsheet attached , and I was given a macro to calculate an average speed, on column M
Screenshot - 10_17_2017 , 10_50_53 AM.png
I have uploaded the macro
Screenshot - 10_17_2017 , 10_51_12 AM.png

But how to know that it will work? how do I make it work?

Any input is welcome, many thanks!
Alex

Originally Posted by AB33

There are two types of programming in VBA: Functions and Procedures.
A function usually return a value like sum function in excel.
A procedure does not return a value, but execute a code- it does something.
You have procedure, so you have to run it to get the code executed. You need to go in to the module by clicking the visual editor button and while you are inside the module you press F5 or click the run button at the top of the window.

You can attach the code to a button. When you press the button the code runs.
How do you know the code runs? Well, if you do not get an error, it means the code run successfully , but it does not necessarily mean the code is right.
I can not run and test the code as you have another procedure attached to the code-wkbkName = frmSelectWorkbook.SelectWorkbook. I other words, the code can not run as it is now as part of it is missing.

Thanks AB33, something is not right, I need a little more guidance:

so i have my average speed in modules
Screenshot - 17_10_2017 , 11_14_30.png
I press F5 and get ready to run the macro...
Screenshot - 17_10_2017 , 11_14_58.png
I get this error
Screenshot - 17_10_2017 , 11_15_08.png
and this is from the debug....
Screenshot - 17_10_2017 , 11_15_21.png

what's the problem?

you said you cannot run and test the code as I have another procedure attached to the code-wkbkName = frmSelectWorkbook.SelectWorkbook.
and that the code can not run as it is now as part of it is missing. ... so you are saying that part of the macro code I attempt to apply
is missing? how do you know?

Originally Posted by bakerman2

This way the code runs. It creates a new column X with results.
Wether these are correct that's for you to review.

Ok it worked in that specific spreadhseet. I don't know what you did to it, but then it won't apply to other spreadsheet... sorry, this is trivial I know, just don't understand how to make it work to another spreadhseet?

Screenshot - 17_10_2017 , 11_47_31.png
I run it, it asks to chose the spreadsheet, i chose a new one
Screenshot - 17_10_2017 , 11_47_45.png
error
Screenshot - 17_10_2017 , 11_47_52.png
debug
Screenshot - 17_10_2017 , 11_48_00.png

I need to know how to make this work on other spreadhseets as well, besides in the one that you attached.

many thanks!
Alex

Or, if there is a way around this, for example, just create a formula that will calculate automatically the 15 minutes average speed on column M based on the
time in column C, how to do this?

Screenshot - 17_10_2017 , 11_14_58.png

When you see a line which is highlighted in yellow, it means the code errors and stops going into next line.
You have not posted the entire code- part of it missing and that is why the code is telling you that it could not find another code called frmSelectWorkbook.

Originally Posted by AB33

When you see a line which is highlighted in yellow, it means the code errors and stops going into next line.
You have not posted the entire code- part of it missing and that is why the code is telling you that it could not find another code called frmSelectWorkbook.

Then I'm confused. You uploaded a spreadhseet with the working macro. Then I wrote back saying that it works fine in that one you uploaded but it doesn't work if I try to apply
to others... not sure what do you mean that the code is missing... if it is missing it wouldn't work for u as well, but you had it working, 4 posts above, ( Today, 05:31 AM ) with the newly added X column..