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 Surendra7

Surendra7 has participated in the following threads:

Added by Surendra7 on 19 Dec 2021 at 16:00

Does changing the range for prime test to 

for possible_prime in range(2,int(test_number/2)):

will make code more effiecient.

Added by Surendra7 on 27 Aug 2020 at 17:33

Hi Andrew,

I think I made scroll increase in month increment if clicked on right side using below code

Private mCurrentScrollPos As Long
Private Sub FilmDateScroll_Change()

FilmDate.Text = Format(CDate(FilmDateScroll.Value), "d mmm yyyy")
    
If (FilmDateScroll.Value < mCurrentScrollPos) Then
    
        FilmDateScroll.LargeChange = DateDiff("d", _
                                                DateAdd("m", -1, CDate(FilmDateScroll.Value)) _
                                                , CDate(FilmDateScroll.Value))
Else
        FilmDateScroll.LargeChange = DateDiff("d", _
                                        CDate(FilmDateScroll.Value), _
                                        DateAdd("m", 1, CDate(FilmDateScroll.Value)))
End If
    
mCurrentScrollPos = FilmDateScroll.Value
                                           
End Sub

 

Let me know if there is something else I should consider.

Thanks,

Surendra

Added by Surendra7 on 24 Aug 2020 at 10:04

Dear Andrew,

I went through all of your 22 Excel VBA - Basics over 1 weekend. 

These are best training videos that I have ever gone through free or paid. I have taken many paid and free training videos, but these videos stand out by far. Content is perfect, pace is just right and best thing is that you are not using pre-written codes, that allows viewers like me do the code simultaneously to get hands on. and make notes in the code itself. Even then it never feels that videos are slow or less content is covered. Many others have already commented about your English, it is perfect for a training video.

I just wish I would have watched your videos earlier and had been much more efficient and productive at work.

Looking forward to complete remaining of the 122 VBA videos.

Thanks, Surendra

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