Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How do I fix the below code so if a user does not enter anything in the input
box or clicks on the cancel button they get what I have in the MsgBox? MsgBox ("You did not enter a new pay period start date" & vbCrLf & _ "click on the 'EnterNewPayPeriod' button and re-enter the new pay period") Sub NewStartDate() Dim Prompt, Title As String Prompt = "What's the new pay period start date?" Title = "Start Date" StartDate = InputBox(Prompt, Title) End Sub -- Mike Mast Special Education Preschool Teacher |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
A simple inputbox & responding msgbox coding | Excel Discussion (Misc queries) | |||
Help with InputBox and MsgBox | New Users to Excel | |||
msgbox / inputbox etc | Excel Discussion (Misc queries) | |||
msgbox / inputbox etc | Excel Worksheet Functions | |||
msgbox / inputbox etc | Setting up and Configuration of Excel |