Can I write event procedures at shapes object level? How?
Dr.Il

--
Dr.Il
-----------------------------------------------------------------------
Dr.Ile's Profile: http://www.excelforum.com/member.php...fo&userid=1597
View this thread: http://www.excelforum.com/showthread.php?threadid=50668

Yes you can have mouse_click event associated with a shape object. Onc
you have a shape ( picture, drawing object, clipart etc ) on the sheet
right click on the shape, choose " Assign Macro " and then assign an
procedure to this shape. This procedure will execute when you click o
the shape.

A V Veerka

--
avveerka
-----------------------------------------------------------------------
avveerkar's Profile: http://www.excelforum.com/member.php...fo&userid=3033
View this thread: http://www.excelforum.com/showthread.php?threadid=50668

Thank you avveerkar,
Any suggestions if I have n lines (n20 and is changing)

--
Dr.Il
-----------------------------------------------------------------------
Dr.Ile's Profile: http://www.excelforum.com/member.php...fo&userid=1597
View this thread: http://www.excelforum.com/showthread.php?threadid=50668

Dr.Ile Wrote:
Thank you avveerkar,
Any suggestions if I have n lines (n20 and is changing)?

Sorry, I don't understand your question. 20 lines of what? Associatin
mouse_click event to a shape would not depend on any line count. Yo
will need to define your problem again.

A V Veerka

--
avveerka
-----------------------------------------------------------------------
avveerkar's Profile: http://www.excelforum.com/member.php...fo&userid=3033
View this thread: http://www.excelforum.com/showthread.php?threadid=50668

Sorry for nontrasparent question. I'll try in a different way:
At the beggining of my procedure I don't know how many lines there will
be. I get their number from running specific procedure. So, number of
lines is dependent of my input in this specific procedure. Because of
these dependenties I want write a procoderu who will first read the
number of lines and then assign them event procedures or macros (your
way).
Thank you
PS:Sorry for my language:)


--
Dr.Ile
------------------------------------------------------------------------
Dr.Ile's Profile: http://www.excelforum.com/member.php...o&userid=15975
View this thread: http://www.excelforum.com/showthread...hreadid=506688

Dr.Ile Wrote:
Sorry for nontrasparent question. I'll try in a different way:
At the beggining of my procedure I don't know how many lines there will
be. I get their number from running specific procedure. So, number of
lines is dependent of my input in this specific procedure. Because of
these dependenties I want write a procoderu who will first read the
number of lines and then assign them event procedures or macros (your
way).
Thank you
PS:Sorry for my language:)

I am again sorry, I am still not with you. By number of lines do you
mean number of used rows in a worksheet? Or you are referring to number
of lines of code of your procedure? If it is later case then I do not
know what exactly you are referring to because I cannot visualise a
situation where number of code lines can change. In the former case,
are you saying that the number of rows used is not fixed and you want
to write a procedure to first find out how many rows are used and once
you know the number then you want to evluate those rows? There is a
method called CurrentRegion which will return a used range and then
using Rows.Count you could find out number rows in the range. Is that
what you are looking for? Else you need to tell me what exactly is your
application. Sorry for being such thick-headed.

A V Veerkar


--
avveerkar
------------------------------------------------------------------------
avveerkar's Profile: http://www.excelforum.com/member.php...o&userid=30338
View this thread: http://www.excelforum.com/showthread...hreadid=506688