Forum Discussion
Solved
VBA
I can run a macro to put XXXX were I want but what I'm looking to do is, when I click anywhere on the big square it will place 1 X in the oval shape then when I click the big square again it will again place an other X ,,,, Please click On Subject to see tagged file if not visable
The easiest way to get rid of the problem is to create a new macro with the same name creatX.
I have done so and added some functionality, perhaps you can use that as starting point.
Create the following macro and assign it to the rectangle:
Sub Rectangle1_Click() With ActiveSheet.Shapes("Oval 2").TextFrame2.TextRange .Text = .Text & "X" End With End SubHansVogelaar Am I wrighting this wrong
You didn't copy the code correctly. See the attached version.
