changing cell value in vba at current row

[KAPearson]

Hi there, First I'm a total newbie so sorry if this is too obvious but I'm working with VBA and excel 2003 and I want to change the value of a cell. Sounds simple but.. I've cobbled together code which allows me to use a drop down box to select a name from column B and can even select the corect row and clear all the data on it. But I can't then enter data in certain cells on that row. Here's my code:

Please Login or Register  to view this content.

I've emptied the row and now want to add "zzz" to (current row, column B) as well as "01/01/2099" to other cells on the same row.

Thanks for taking pity on a newbie!
Ps thanks for putting me straight about code. Got it!

[Russell Dawson]

Hi and welcome,

A word to the wise. You will get your hand slapped for not putting the code in tags as per the rules:

Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Select your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button). The result will appear like this in the post window:

"code"
your code here ...
and here ...
and here "Code"


... and appear like this when posted:

Please Login or Register  to view this content.

You can also type the code tags in manually if you prefer. For more information about these and other tags, click here.

[TMS]

Welcome to the forum. And beware ... in your first post, you have broken two of the forum's rules. Non-specific thread title and missing code tags.

You're going to have to do something about this rule breaking before anyone is permitted to answer your question(s).

Kind regards, TMS

[KAPearson]

Thank you for the advice. Consider me bashful. I'm off to sort it now.

[KAPearson]

Thank very much I think thats sorted it?

[TMS]

I think this is what you want:

Please Login or Register  to view this content.

Regards, TMS

[TMS]

Oh, and thanks for the rep

[KAPearson]

Thanks TMShucks, that works a treat! I was going around in circles!
Thank you very much.

[TMS]

You're welcome.