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

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

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

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

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

Hey Tom,

Thanks, this looks like it will do the job.

-Minitman



On Thu, 21 Oct 2004 12:47:12 -0400, "Tom Ogilvy"
wrote:

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