Test UserEntry for "Quit" or something similar.
Test UserEntry for "Quit" or something similar.
Try this
![]()
Option Explicit Sub Fill01() 'Worksheets("SINGLE PHASE CONSTRUCTION").Activate Dim UserEntry As String UserEntry = InputBox("What is the W/O #?", "INPUT W/O") Select Case UserEntry Case "": Exit Sub Case Else: Range("B2").Value = UserEntry End Select End Sub
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks