Browse 531 attributed reviews, viewable separately for our classroom and online training

Details for Kayvan

Kayvan has participated in the following threads:

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.

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 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