Our training courses
Azure C# Excel Microsoft 365 MySQL Power Apps Power Automate Power BI and DAX Python Report Builder SQL SQL Server VBA Macros

Other training resources
Blogs Exercises YouTube tutorials YouTube shorts Test your skills Consultancy Courseware Self-paced courses Newsletters Publications

Our training venues
London Manchester Across the UK At your site Online

Why we are different
Hundreds of published reviews Small class sizes Outstanding courseware Online classroom (Almost) no cancellations Wise Owl trainers only Genuine integrity Invoices after training 30+ years of Wise Owl Our top 100 clients

Details for Kayvan

Kayvan has participated in the following threads:

Added by Kayvan on 17 Sep 2020 at 16:42

Hi Andrew,

Many thanks for your previous response.

Can we write our code like the following for this exercise:

If Not IsDate(Range("B3").Value) _
    And Not IsNumeric(Range("B4").Value) Then
        Range("A5").Value = "Enter a valid data"
        Exit Sub
    End If

If we can, why do I receive the wrong result?

Sincerely

Kayvan

Added by Kayvan on 16 Sep 2020 at 13:51

Hi Andrew,

Many thank you for your great course in VBA that I've ever had in whole my life.

I have two questions:

1- What is the difference if we write 

If Range("B2").Value > Range("D2").Value Then

                     "Versus "

If Range("B2") > Range("D2") Then

That is, if we don't write .Value in our IF statement?

2- I got your book in Black & White and I'd like to know if I can get the colored version like the in-text section of your training as it helps a lot to recognize line, command, and error section easier and better.

Sincerely

Kayvan

Added by Kayvan on 24 Feb 2020 at 02:45

Hi Andrew,

If I had an instructor like you when I was in university, I wouldn't have become an Engineer and I became the best computer programmer.

The sequence and the logic of the VBA command that you teach make more sense why the learner needs another command to tackle the task.

Anyway, I was lucky enough to find your course and ordered your book. I hope I have an opportunity to learn more about your other courses like Power Query and Power BI. I live in the USA and I wish I had a chance to participate in your onsite classes.

Head office

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

London

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Manchester

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE

© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.

End of small page here
Please be aware that our website uses cookies!
I'm OK with this Tell me more ...