Execute code via curser position?

[Tellus]

Hi,

I have a problem I can not solve on my own...


I have a text box (Text Box A) in a worksheet.

By moving the mouse cursor over Text Box A (not clicking) I would like to activate some VBA code, making another text box (Text Box B) appear.

By moving the cursor away from Text Box A I would like to run some other code making Text Box B disapear.

ANY suggestions are welcome!

[rylo]

Hi

This is pretty clunky but try using the mousemove and selection change events. Assumes that the first textbox is called textbox1, and the second one is textbox2.

Moving the mouse over textbox1 will show textbox2, and moving the cell selection will make it invisible.

Please Login or Register  to view this content.

Another option may be to invoke an ontime event that will make textbox2 visible = false after say 5 seconds.

HTH

rylo

[Tellus]

Thanks alot!

I went go for the OnTime-suggestion and it works excellent!