Dim dt as Date
Dim sh as Worksheet
dt = cDate(Textbox_3.Text)
Set sh = worksheets(format(dt,"mmm-yy"))

--
Regards,
Tom Ogilvy

"Minitman" wrote in message
...
Greetings,

Here is the second question:

After I have entered the information I need into my UserForm
TextBoxes, I need it placed into a spreadsheet. But not just any
spreadsheet! I have my sheets named by month (mmm-yy). What I need
is a way for the code to determine which sheet to place this record at
the bottom of. I need this to be determine by the date entered into
TextBox_3.

Any help would be most appreciated.

TIA

-Minitman