Excel Visual Basic for Applications online training

This page has 0 threads | Add post

Finding our tutorials useful? Please consider helping us to share more!

You must enable JavaScript to be able to view our online training courses (the tabbed menu below doesn't work otherwise).

Messages and User Inputs

Exercise 5.02

The aim of this exercise is to allow the user to add items to a list using input boxes.

Files Needed

Click here to download the file you need for this exercise.

Instructions

Open the Lottery List.xlsx file, create a new module and add a new subroutine.
Congratulations: you've won the lottery! Your task is to write a procedure which uses input boxes to build a shopping list.

Feel free to delete the suggested items that are already in the list.

Write code to display an Excel input box which asks the user to enter the name of the item they wish to purchase. Capture the result in a String variable.

Be as extravagant as you like.

Add code to check that the user entered a value before clicking OK. If not, display a message and exit from the procedure.

We don't want to add an un-named item to the list.

Add code which displays a message and exits from the procedure if the user clicks Cancel on the input box.

Your message can be gently encouraging or downright pushy.

Add a second Excel input box which asks the user the estimated cost of the item and return its result to a Double variable. Make sure that the user can only enter a number.

If you don't enter a number you should see this warning.

Write code to add the new item to the end of the list.

The new item should appear at the end of the list.

Answer Files

Click here to download a file containing a suggested answer.

This page has 0 threads

Add a new post

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

Site map

Terms & Conditions

Book any course as classroom, onsite or online training, or as one-to-one consultancy

Free resources

Paid services

Getting help

Where we are

Where you are

Online

Transparent reviews

Delivery of courses

Nicer to work with

Reliable and established

Our training courses

C#

Excel

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

MODULES

EXERCISES

Exercise 5.02

Files Needed

Instructions

Answer Files

Head office

London

Manchester