Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input Box Question
Please forgive me if I have asked this before, but I searched the threads and
cannot find an answer. I have a workbook with 31 sheets in it. Each sheet is used for a different day during the month to enter data. I am attempting to put a macro in place to copy unique values to separate sheets from one user defined sheet in the workbook, but I do not know how to let the user tell the macro which sheet to sort and copy. I think that I have the Input box set up correctly, but don't know how to incorporate it into the code. Here is what I have so far: 'Name of the sheet with your data Dim strWhichSheet As String strWhichSheet -InputBox("Enter sheet name to sort", "WhichSheet", "WhichSheet") If strWhichSheet = "" Then End Set ws1 = Sheets("WhichSheet") Then goes on to execute code to copy the unique values on one sheet to several sheets. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Input box question | Excel Programming | |||
Input Box Question | Excel Programming | |||
Check Input, into Input box question | Excel Programming | |||
Input Box Question | Excel Discussion (Misc queries) | |||
Input box question | Excel Programming |