WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
Wise Owl Training
See 519 reviews 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