If you are using buttons on a userform to select the ranges you don't need a
worksheet event--you can just put in the button code what you would like to
do with the selected range.

Once the range is selected, you can store the address of the selected range
in a variable, as in:

sAddress = Selection.Address

HTH,
Shockley


"Filip Mateasko" wrote in message
...
Hi, I have 2 following problem.
1) I'm not familiar with using of events in VBA and I'm not able to find
some good help on the Inet. Do you know some ? I'm not able to find in at
MSDN.
2) I need to create application which will this: I need to open some
userform, where using the buttnos will be possible to select several
ranges
in the Sheets and store their addresses in the variable. Then I¨ll use
these
ranges in several next processes. My problem is, that I don't know, how to
do it, to be able from userform select some range in the sheet. The
function
should be similar as is for ex. in the chart, where you can specify the
range of source data. I think this has to be solved using events, but I
don't know how.
Thanx
Filip