- Jun 19, 2013
I need to limit the number of Characters that can be inputted to the popup InputBox to just 31. How do I set MaxLength? Code I am using is listed below.
Sub NewRecipeSheet() Dim ws1 As Worksheet Set ws1 = ThisWorkbook.Worksheets("1. Recipe Master Sheet") ws1.Copy ThisWorkbook.Sheets(Sheets.Count) Application.Goto Reference:=Sheets("1. Recipe Master Sheet").Range("A1") Range("A1").Value = InputBox("Menu Item Name?") End Sub