| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select sheet based on userform date input
I have a workbook that is used for scheduling deliveries. Sheet 1 is a "Control Panel" which among other things will pop up an entry form for "New Deliveries". Sheet 2 is set up as a list which receives the data from the userform. This all works as desired presently, but I want to write the data from the userform to a separate sheet by month based on the delivery date entered on the form. The form has a permanently visible calendar which when clicked writes the selected date to a text box right below the calendar (as mm/dd/yy). How can I pull the month only from the text box and use it to determine which of the monthly sheets will be activated for writing the data from the form? -- mugitty ------------------------------------------------------------------------ mugitty's Profile: http://www.excelforum.com/member.php...o&userid=30713 View this thread: http://www.excelforum.com/showthread...hreadid=503804 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to select a specific range based on the time value of user form input | New Users to Excel | |||
| Select cell from range based on input in excel xp | Excel Discussion (Misc queries) | |||
| Userform-Change textbox color and font based on input in other tex | Excel Programming | |||
| CODE to select range based on User Input or Value of Input Field | Excel Programming | |||
| select data based on user input | Excel Programming | |||
Threaded Mode
