Help with code please

G

Greg B

I am wondering how to change this code a little so if the person hits cancel
button on the inputbox it just exits back to the main menu called "main"

Dim ROUND1
ROUND1 = InputBox("WHAT ROUND IS IT?", , Val(Sheet1.Range("B3") + 1))
WEEK1.Visible = False
WEEK2.Visible = False
PRINT1.Visible = False
PRINT2.Visible = False
VIEW1.Visible = False
VIEW2.Visible = False


Thanks
Greg
 
L

Les Stout

Hi Greg,

A simple solution is

Dim ROUND1
ROUND1 = InputBox("WHAT ROUND IS IT?", , Val(Sheet1.Range("B3") + 1))
If ROUND1 = "" Then
main
End If
WEEK1.Visible = False
WEEK2.Visible = False
PRINT1.Visible = False
PRINT2.Visible = False
VIEW1.Visible = False
VIEW2.Visible = False


Best regards,

Les Stout
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with code please 2
Help on following code please? 2
Please help with code! Thanks! 1
Problem with code used in other countries 5
help with code please 3
Help! Please help with my code 4
Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read f 4
Help with code please 1

Top