Input Words in Sequence

[Stews]

Hi excelers,
I'm not that familiar with VB, but need any help on my attached spread-sheet panel for kids who need to input words (learning type app

As you can see from my panel, when a word button is pressed, I need that word to appear in the "input data" string (bottom left).
Furthermore, it needs to be in sequence (word by word); thus when the "red" button is pressed "red" appears first, and when the "hard" button is pressed then the word "hard" appears after "red" in sequence, etc...

Input panel example:
( Red ) button pressed
( Hard ) button pressed

Input Data:
A25 B25
red hard etc...

I hope the problem is explained clearly, if not, please let me know. Thanks for any help....

[cytop]

Not altogether sure what exactly you are trying to do (actually I haven't got a clue), but if you want to list the captions of the shape clicked along row 25 then

Please Login or Register  to view this content.

You will have to remove the formulas first, though...

[mrice]

If you are happy to have row 25 initially empty, the following should work.

Please Login or Register  to view this content.

[Stews]

Hi Cytop and mrice,
When I copy your code into the VB panel, and when I click a button the error box appears "Ambiguous name detected: Mark"
Would it be possible to input the code for me so that it works. again thanks

remember the "red hard" was a example and needs to work for all the buttons, etc...
So if I click say "square" or "light" button this also needs to appear in the
Input Data cells in sequence i.e. square then light in each cell that follows.

[cytop]

You can only have 1 procedure named 'Mark'. That error simply means there is more than 1.

Rename the existing procedure and assign the Macro to all tge shapes on the worksheet (Right click a shape and select 'Assign macro...')

[Stews]

Cytop, I have done this but it still does work!
I grateful for your help, if you could assign the first one... I can then copy what you have done.

thanks again Stewart

[cytop]

Attached.

New Input.zip

[Stews]

thanks that works very well.