Active x command buttons

So you were able to get the commandbutton to change it's color upon clicking? The second part is even easier then:

Please Login or Register  to view this content.

Thats assuming that the range will be static. If you must find a string first and then type something next to it, then let me know. It would be of course best if you would attach an example workbook

cheers

Sure, you can change it for it to send the info to another workbook:

Please Login or Register  to view this content.

Hi I have put the following code on a command button, the colour change works and the sending an email works however I cannot get it to link to another spread sheet have I done some thing wrong do I need to link the spread sheet somehow?

Thanks

Ben

Please Login or Register  to view this content.

Hi Benjamin,

first of, you might want to wrap your code with [code] and [/ code] (without the unneeded space). Otherwise you might get into some troubles ^^

Now to your problem:

Workbooks("test").Sheets(1).Range("A12") = " has been read"

Do you mean that there is no "has been read" in cell "A12" in the first sheet of test? I'm pretty sure that the code is ok. Is the worksheet protected? Does it contain a chart? Is it open at all? There are many reasons why it might not be working in your case - the easiest way for me(or anyone else from the forums), to help you, would be you attaching the workbook which ain't working. If the text does not appear in A12, there has to be something unusual about your workbook,sheet,pc etc. that you haven't informed me about.

Please Login or Register  to view this content.

you used

.activate

wrong I'm afraid.

Check out the first part of my last post. The solution is in there.

I think there's some misunderstanding going on currently. Please take a look on the code i provided you with two posts ago:

Please Login or Register  to view this content.

this one actually works. Swap it with the current one and you're ready to go.

try deleting the "set".

[code]filepath = "C:\Users\NM373IT\Documents\Process's\"

I have deleted that part entirely while checking the previous code, thus couldn't catch the error.