Simple Action. Please, could someone tell me how to do this?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shapper - 13 May 2008 15:27 GMT

Hello,

I have 16 images each one inside one cell in an Excel Worksheet.
Each image is named: img1, img2, img3, ...

Every time a user clicks an image I want to call a VB function named
MyFunction and send the image ID and its position ... how can I do
this?

And from that function how can I change the image visibility?

I have been using C# and VB.NET for a long time but in Visual
Studio ...
I am a little bit confused how this kind of interaction works with
Excel.

Thanks,
Miguel

Reply to this Message

Don - 13 May 2008 21:05 GMT

> Hello,
>
[quoted text clipped - 14 lines]
> Thanks,
> Miguel

You have to create a different routine for each image. And then you
can set each image's visibilty.

for img4:
private sub rout4()
ActiveSheet.Shapes(img4).Visible = false
end sub

Reply to this Message

Tim Williams - 14 May 2008 03:15 GMT

This group is more about programming using VBA within Excel.
For .NET / VSTO you might get more help in a .NET group

Tim

> Hello,
>
[quoted text clipped - 14 lines]
> Thanks,
> Miguel

Reply to this Message