assigning code to buttons

Hi,

You need to name the macro's differently

So for example change one of them as count and the other as count1

The macros need to be against the sheet rather than a separate module (I think)

then go to your worksheet, right click the Yellow4 textbox and asign macro count then repeat for the green3 text box

Now when you clock on Yellow4 textbox it should run the macro.

Hope that helps

Thank you wagstaff
I got it now...

Sorry Roy, I am new to all this and was never on a thread site before either.
I was having trouble locating my other postings and didnt see your earlier reply.
Thanks for the info though.
I wrote the code in the visual basic window..
created text boxes in excel.... then right click on the boxes and clck assign macro.
works perfect for what I want now... thanks

Glad I could assist, thanks