Placing textbox value into save copy's cell...

First and foremost, allow me to say "hello" as this is my first post. I hail from a land known as Google where I seek a solution for my Excel trials and tribulations and when I saw the overall post counts, I figured this would be a good place to go for help...

So anyway, here's my issue: How can I take what a text box contains and place it in a cell?

That helped, Leith, but now I'm having problems with the following:

Please Login or Register  to view this content.

Whenever I try to run the code, it keeps bombing with the following error message:
"Run-time error '438':
Object doesn't support this property or method"

As I'm sure you can tell, I'm a complete novice to this VBA stuff, but the thing is that I'm a decent programmer with other languages (PHP, MySQL). I'm curious about how you pinpoint line-numbers in VBA because Microsoft's Visual Basic Editor doesn't seem to do very well with showing me (the complete buffoon) which line number the code breaks on here... So to compensate for this, I simply used a MsgBox statement before and after that line above--that's how I know it has something to do with this specific line (is this a good way to pinpoint trouble lines?).

Anyway, any help with the above is very appreciative.

Oh, and BTW: "drp_project" is a simple drop down list element. I had thought that using "Shapes(...)" was a good way to target it, but it seemed to fail, too... I'm at a loss.

Unless I'm mistaken, I believe I made it from the "Control Toolbox" where I then used "Validation" to populate the box from another sheet where the list was that I used for the options.

Sure, but beware that again, I'm new at this and what you behold is liable to startle you... Ha.

Please Login or Register  to view this content.

Leith, thanks for your patience with me on this.

As for posting the workbook, sure, but give me a day to get my affairs in line (I'm currently scrambling with some homework and other stuff.) I'll try to post that tomorrow sometime when I get back from work and change some of the values around to protect identities, etc.