old excel macro language

[command_z]

Hi all- I just found this website. I wish I would have found it years ago! I am wondering if I am the the only dinosaur out there still using the old macro commands??? I just cant bring myself to use/learn visual basic

 

[My Aswer Is This]

I started using

LOTUS 1-2-3 in USAF
Then using HYPERCARD a Apple product.
And then

Excel 4
And on and on.
I figure you have to move with the times.
I find basic command in Excel Vba easy to understand but when it comes to doing things the fastest considering milliseconds don't count on me for the fastest code. And I like using code I understand even if it takes another 3 seconds.
​

<strike></strike>
​

 

[rlv01]

VBA has a sort of similar wait method

<code>If Application.[B]Wait[/B](Now + TimeValue("0:00:10")) Then
    MsgBox "Time expired"
End If</code>

 

[Mabocat]

I just tried

<code>Application.[B]Wait[/B](Now + TimeValue("0:00:10")</code>

and it gave a syntax error - is it because I didn't use the full words of If etc

I don't want a message box, just to wait for the seconds I nominate then carry on with the rest of the macro

 

[rlv01]

You don't have to use a msgbox, that's just for the example.

Sub WaitTest()
    Debug.Print "Waiting for 10 seconds...."
    
    Application.Wait (Now + TimeValue("0:00:10"))
    
    Debug.Print "... now continuing code execution"
End Sub

This produces a 10 sec delay.

 

[Michael M]

@Mabocat....your missing a bracket at the end of the line !!
@MAIT...I'm with you on understanding rather than faster

 

[Mabocat]

Thanks Michael, that fix it.

Ron

 

[Mabocat]

I will use some of the info provided on this thead for a new thread soon.

Ron