How To Get A Set Entries To Paste To The Bottom Of The Correct Sheet

[Minitman]

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

 

[Tom Ogilvy]

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

 

[Minitman]

Hey Tom,

Thanks, this looks like it will do the job.

-Minitman