Hello, I have this code that has a couple of input boxes. I just noticed a flaw, if I press cancel or exit out, the code still runs. Is there a way to stop the code if user presses cancel on any of the input boxes and stops the code from creating a sheet?
Here is my code
Thanks.
Please Login or Register to view this content.
Maybe test: If employeeID = "" Then Exit Sub
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Sorry I am not an expert. Can you kindly show me how to use it in my example code above?
Not without a sample worksheet but there's always someone willing to do it without one.
Please Login or Register to view this content.
Because copy first, then input box.Originally Posted by wherdzik
Try this:
PHP Code:Sub Add_Physician()
Dim employeeID
Dim LastName
employeeID = InputBox("Enter Employee ID")
If Len(employeeID) = 0 Then Exit Sub
LastName = InputBox("Enter Employee Last Name")
If Len(LastName) = 0 Then Exit Sub
Sheets("Template - Phys Standard").Copy Before:=Sheets(1)
Sheets(1).Name = employeeID & "_" & LastName
Range("E7").Value = employeeID
End Sub
Quang PT
Oh wow...thank you Jindon and thank you bebo021999...Your solutions are beautiful.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks