based on cell selection in sheet1 values appear on sheet2 in one sentence

[VBABEGINER]

Sheet 1

column A	column B	column C	column D	column E
Task list	Task Id	sever name	application name	action
open	T_1	S_1	abc	reset
close	T_2	S_2	pqr	cancel
hold	T_3	S_3	xyz
	T_4		mango
	T_5		chilly

Hello All Board member's,

Hope you all are doing well..!!

I've data like above chart on sheet1. What I'm trying to do is,
suppose if I click on cell -
Task list - open (highlight this selection in green) then
Task Id - T_3 (highlight this selection in green) then
server name - S_2 (highlight this selection in green) then
application name - chilly (highlight this selection in green) and then
action - reset (highlight this selection in green)

and click on "Submit" button.

then on sheet2 starting from row 2, let's say, A2 i should have output like this-
"open T_3 S_2 chilly reset" in single cell

The way I click on cell green color will appear for every cell selection and lastly clicking on submit button will save that selection data in sheet2.

 

[VBABEGINER]

Hello All,

I just got one code which was given by (he is too my very favorite) Vog Sir.. This is the code..

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
Target.Interior.ColorIndex = 0
End Sub

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
Target.Interior.ColorIndex = 4
End Sub

Now with the help of this code, whenever I'm selecting a cell (with the help of right click) it turns that cell into Green color. If User made wrong selection on the same column there "before double click" event code also available to make that cell colorless.

Now.. can any one pls provide a code on button, that whatever be the green selected rows are to be copied in single cell in sheet2..


Pls reply, let me know if anyone need more explanation.. Thank You..

 

[VBABEGINER]

Hello Board.. I'm closing this post. As I've achieved next level of this.. Thanks..!!