access vba course - Vba Message Box

The UK's most regular instructor-led training courses.
Training information: access vba course · Excel london

Resolved · Low Priority · Version Standard

Vba Message Box

Dimitrios has attended:
Excel Advanced course
Excel VBA course

by - delegate Dimitrios [4 posts] (2007 Jul 9 Mon, 11:38) Reply

Hello,

I would like to create a message box where it will say: "Copy yesterday's data?". If the user replies yes, then i want it to execute the macro that i have created in VBA (named Main) eitherwise do nothing. So far, my macro lloks like this:

Sub Main()

Application.ScreenUpdating = False
Prices
Weights
Values
Exit Sub

Dim reply As Integer

reply = MsgBox("Copy Yesterday's Data?", vbYesNo)
If reply = vbYes Then

Else
Resume
End If

I am not sure what to add after the THEN in order to make it run the MAIN sub. any help will be greatly appreciated.

RE: Vba Message Box

by - trainer Carlos gold contributer [360 posts] (2007 Jul 11 Wed, 15:43) Reply

Dimitrios

After the THEN you enter the following line:

Call Main

This runs the Main macro.

Regards

Carlos

· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· Company Roles in Visual Basic Training

Vba tip:

Count the Rows and Columns in a Selection

If you need to count the number of rows or columns in a worksheet use the following code:

Selection.Rows.Count - Returns the number of rows in the selection

Selection.Columns.Count - Returns the number of columns in the selection

Selection.CurrentRegion.Rows.Count - Returns the number of rows in the current region of the selection

View all VBA hints and tips