Excel VBA create command button

[peterd51]

Hi,

I can create a button in Excel and add a macro to it...

next I want to have 'up' and 'down' arrows that the user can click on and it'll toggle a search on that column, then replace the existing arrow with the other one for next time.

I can do the search OK, it's changing the picture that has me beaten.

I tried using the 'arrow-lines' but it's messy as it adds a new 'line' number each time it's written and I can't delete the old one as I don't know the number.

So now I have two small .jpgs and I can load them up into the selected cell with, for instance...

Range("B1").Select
ActiveSheet.Pictures.Insert ("C:\up.jpg")

But I can't see how to delete a single picture when I load up the 'other' one, I can only delete /all/ pictures on a sheet with ActiveSheet.Pictures.Delete.

Also, how could I position the pictures to the right of the cell allowing for a title on the left?

Or is there a better way of doing this please?

Regards
Peter

 

[Golom]

Probably better to ask in forum707. This is VB5 & 6.

 

[peterd51]

Hi,


sorry, I didn't see it'd changed forums on me!

Regards
Peter