Hi!
It didn't work. I added this to the sheet1 tab in VBA editor and it did
nothing. I am using a drop down meny useing the validation option.


"mrice" skrev:


Never under-estimate Excel....

If you add this sub to the sheet1 tab in the VBA editor

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
If Target < "" Then
Cells(1, 2) = Cells(1, 2) & "," & Target
End If

End If
End Sub

this will add values into B1 from a drop down in A1


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=544782