Excel 2003 Macro to open Workshhet based on textbox value if not found create new WS

Dear All,

I am new to this forum and looking your guideline on Excel 2003 vba.

I have userform which transfer data from userform to worksheet. It is working perfect, but I would like to transfer data to a specified (textbox value)worksheet, if specified worksheet not found then copy previous worksheet and rename to textbox value then transfer data.

Thanks in advance for your input.

I'm not sure what you mean by previous sheet so you might need a slight modification
This code creates a copy of "sheet3" with the name specified in the textbox if a sheet with the name specified in the textbox does not already exist.

Please Login or Register  to view this content.

Thanks for your reply. Return with compile error. This may be due to textbox value is date. To make more clear, My workbook contain many worksheets each named with date e.g 01.01.12. The userform on click transfer data to relevant sheet based on textbox value (date), if the date is new, no sheet found with, then it copy, rename to new date and transfer data.