save and read data from cell

**ditisFloris** · 10-28-2010, 07:48 AM

ok, I don't know exactly how I can explain this.

maybe you can follow me if your looking at the attachment.

i want the user to type text in a cell (i10:m24)
when he clicks on a choice dot the data in the cell must be put into another cell on a different sheet. at the same time, the data from the matching cell must be put into cell (i10:m24).
the user can change that text, en when the next (or previous) dot is clicked, the data have to be put into a cell at the other sheet, and the next data has te be loaded.

point is it saves the answer to each question on another sheet.

i'm a 2 week newbie in VBA and been buzzy on this macro for 2 days. thought it couldn't hurt to see if someone gets my situation and is willing to help.

best regards, Floris

**Marcol** · 10-28-2010, 08:17 AM

Best if a Dutch speaker looks at this one. Anyone?

**arthurbr** · 10-28-2010, 09:06 AM

I contacted rwgrietveld to see if he can help

**ditisFloris** · 10-28-2010, 09:46 AM

thanks for the responses. the dutch text in the excel sheet is not important, but I might just explain the situation better in dutch.

**ditisFloris** · 10-28-2010, 10:14 AM

ok never mind guys..

only thing I did wrong was the dimension of the variable I used for counting.
In every macro i had "Dim p as .."
But to let all the macro's use the same variable I had to put "Public p As Integer" on top of the module. (shame..)

took me some time, but learned another thing today

my project is far from finishing, so i'll speak to you soon