Our training courses
AI - Articial Intelligence 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
Tips and tricks Guides and tutorials 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 zeno

zeno has participated in the following threads:

Added by zeno on 15 Mar 2017 at 16:36

Dear Andrew et al I have been studying and enjoying your amazing videos for quite a while a while. I managed to (1). Create a payment system with vba code with application inputbox (2). I created vba code to review the payment system  in (1) to ensure accuracy of date entry. 

The first problem I have now is that when I run the review code and if no change was made to the payment entry in (2), the original entry are being changed to either '£0' or 'false' I have been scouting through the internet for solution to no avail. Please what vba code to write so that the original entry is not changed if no change is made at the review code stage?

The second problem I have is with the following code:

ActiveCell.Value = PaymentAddress
    Worksheets("PCN Form").Select
        For Each Cell In Selection
              Do
            If ActiveCell = "" Then Exit Do
        Cell.Value = UCase(Cell.Value)
        On Error GoTo 0
   Exit Sub
 Loop
 Next Cell

Application.DisplayAlerts = True
Application.ScreenUpdating = True

On Error GoTo 0

End Sub

When I place this code at the begining or middle or procedure, it stops after running without completing other procedures. I have therefore being constrained to put this procedure at the end. Otherwise, would prefer to bring it in the middle.

The third problem I have is how to write a vba code to validate a payment_reference  to contain alphanumeric and also not more than 10 digits.

Can't thank you enough for your amazing videos. Keep us tuned! Kindest regards Zeno

 

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