application.ontime with parameter passed

baitmaster

Well-known Member
Joined
Mar 12, 2009
Messages
2,042
morning all

I am using application.ontime to call a macro. I want to pass a parameter as well, but can't work out the syntax I need

sub exampleMacro1()
' code
end sub

sub exampleMacro2(TF as boolean)
' code
end sub

this works:
application.ontime dtRunTime, "exampleMacro1"

how do I do this for exampleMacro2?
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Code:
application.ontime dtRunTime, "[B][COLOR=red]'[/COLOR][/B]exampleMacro1 False[COLOR=red][B]'[/B][/COLOR]"
 
Upvote 0
Cheers Ruddles... have done a different way now, but good to know how to do this... off to Calne bike show now for the weekend, camping and biker silliness. Awesome
 
Upvote 0
Global variable?

Have fun. My search for a Blackbird continues...
 
Upvote 0
... and has now ended. I picked her up on Monday. I've booked tomorrow off work and I'm hoping the rain holds off so I can go for a tootle.

:)
 
Upvote 0
good work fella! Took mine out on Castle Combe yesterday, still aching now... Off to Scotland in a week or so, taking the young lady for a first short tour

Enjoy ripping up the Gloucester countryside ;)
 
Upvote 0
Mrs Ruddles and I did Skye a couple of years ago by car. There were a couple of big bikes on the ferry and I said then it would be nice to do it on a bike. The roads had just had a major makeover and the locals are so well-mannered, it was a pleasure to drive there. They even pulled over and stopped to let up pass when we came up behind them on several occasions! Long straights, sweeping bends... oh dear, I may have to get the route planner out!

But first we have the Stelvio Pass to do!

Do you frequent any bike forums? I think we're waaaayy off topic here!
 
Upvote 0

Forum statistics

Threads
1,224,599
Messages
6,179,831
Members
452,946
Latest member
JoseDavid

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top