OptionButton Submit Error

[Frankinstyyn]

Hi Guys,

I'm getting an error with the code below.

All I want is whatever option a user picks, "Good" "Neutral" or "Negative" to be moved to Sheet1 A B and C columns when the user presses submit.

Appreciate your help and I've attached the spreadsheet as well.

Thanks in advance

Frank!

Please Login or Register  to view this content.

[HaHoBe]

Hi, Frank!,

emptyRow is emnpty (showing 0, a row that doesn´t exist like that in any Excelösheet), and you miss an End If on each If-Statement like you´ve written it.

Maybe try it like this:

Please Login or Register  to view this content.

Ciao,
Holger

[Frankinstyyn]

Hi Holger,

Thanks for helping me out and it works perfectly and I love the way you've grouped the text.

I've changed it to go onto sheet 3 as that is where I need it.

I have one little thing to be tinkered if possible.

When I press submit the data for good goes to A1, when I choose negative the data goes to C3.

Is there a way to determine the column so in this case negative would go to C2?

Thanks again for your help.

Frank

[HaHoBe]

Hi, Frank,

I´m not so sure I understood what you are asking as I can´t get the reason for placing negative into the same Column C but into row 2. My sample would add the data below any data in the sheet, you may make the ranges permanent by using the row number you want instead of emptyRow. Again: I´m sorry but I can´t pick up the idea why to place the sample value for negative into Row 2 instead of Row 3, perhaps you can clarify on that?

Ciao,
Holger

[Frankinstyyn]

Hi Holger,

Apologies for not being clearer, i'll explain in more detail and hopefully you'll get what I mean

So, the userform is to see team wellbeing within the team, to measure how people are feeling.

If a user selects "Good" it should go into the next available space in column A, so A1 in this case, if another user also selects "Good" it should go into A3.

If however the next user selects "Negative" it should find the next available space in column C, in this case, C2, if another user selects "Negative" it should go below that into C3.

As I need to measure all of the input into a table that's why I would like to get rid of the spaces.

If it can't be done it's no problem, just seeing if a genius, like yourself, can make it happen

Thanks Holger

Frank!

[HaHoBe]

Hi, Frank,

maybe like this :

Please Login or Register  to view this content.

Ciao,
Holger

[Frankinstyyn]

Hi Holger,

That is exactly what I wanted!!

You are a star and a legend, reputation added thanks so much mate.

I'll be posting soon again no doubt!!!

Thanks again Holger.

Frank