Hi all,

How can I do to asign to a variable in a macro the value of the cell selected with the mouse in the excel sheet?
Thanks

Sub Macro()
variable = activecell.value
end sub

this should do it

Hi,

Yes but when I execute the macro, I want to be able to visualize the value of the cell pointed with the mouse in a form. (label.caption or textbox.tex ).
So while the macro is running, the form is showing the value of each cell selected with the mouse.

Thanks for help me.

Mathias

Private Sub Object_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single) 'where Object can be a form, a label, a textbox 'etc
Object.Caption = Activecell.Value (for form, label)
Object.Text = activecell.value (for textbox)
End sub

I think the rest will be simple to you. I hope this is of help

End Sub