text box

[david45]

I have a macro that filter or dose subtotlas
of a worksheet. In the workbook their are about 40 worksheets. This macro filter each worksheet. My question is their away to have text box pop asking which sheet to filter and it will only do that one sheet instead off all of them.

 

[phantom1975]

See if this gets you started:

Dim SheetNum as Integer
On Error Exit Sub
SheetNum = InputBox("What sheet number would you like to filter?","Enter Sheet Number to Filter")
End Sub