Pictures/shapes/buttons/controls don't live on the worksheet itself. They live
on a layer that floats over that worksheet (kind of like the different layers in
AutoCad).

That layer that floats over the worksheet is the excel's drawing layer.

A modeless userform is a userform that doesn't take control of the application.

If you click on File|SaveAs, you'll notice that you can't do anything else while
that dialog is showing.

If you click on Edit|Find (in xl2002+), you'll see that you can click on other
cells and continue to work while that dialog is still showing.



EXCEL$B!!(BNEWS wrote:

thanks for your answer

but i mean i just want to select a shape which is within a excel sheet,
instead of selecting a drawing scope in a cad area,
i dont know the meaning of "selecting anything in the drawing lay"

i think there should be a method to let me do it, in vba,

what does modeless userform mean, would you please give me any hint further,

thanks a lot

"Chip Pearson" wrote in message
...
I don't think you can select a shape using the mouse from VBA
code. Application.InputBox certainly won't do it. I tried to do
it with a modeless userform, but apparently Excel prohibits
selecting anything in the drawing layer.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"EXCEL$B!!(BNEWS" wrote in message
...
hi,

i often use application.inputbox like

Set mycell1 = Application.InputBox(prompt:="", Type:=8)

in order to get a range,

but it failed to let me select a shape, i mean a shape object,
that is a
part of drawing i cilpped and paseted into a sheet,

how to do this,

thanks a lot







--

Dave Peterson