The following placed behind the worksheet of interest will give the value of
the cell the user has entered
The value can be used to set the userform control value property. If you
wish to dtect only certain cells that have change use the second option.

' Value of entered cell (any cell on the spreadsheet
Private Sub Worksheet_Change(ByVal Target As Range)

Target

End Sub

'Value entered from selective cell(s)
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$F$5" Or Target.Address = "$F$6" Then

Target

End If
End Sub

Cheers
N

"John Collins" <oldbutvirile@NO SPAM.btopenworld.com wrote in message
...
How can you extract data from a cell on a sheet (the user has clicked on )
to a userform,
( [adding to the value in the userform] I think I can manage that bit)
then insert that data from the userform back into the sheet?

Thanks in advance






----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---