Thank you so much. However, what if I want to add more status as shown below? When I pressed Cancel or Ok without selecting, error prompt always shows up.
![]()
a: Categorycolumn = Application.InputBox("Which column do you want select?", "Column", Type:=8).Column Select Case Categorycolumn Case False Exit Sub Case "" MsgBox "You have to select!" GoTo a Case Else MsgBox Categorycolumn End Select
Bookmarks