Stephane:
make Worksheet_SelectionChange
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address(0, 0) = "D3" Then
CaForm_Initialize
End If
End Sub
file download:
http://vba.holyou.net/file/9412121.xls
--
天行健，君*以自強不息
地勢坤，君*以厚德載物
http://www.vba.com.tw/plog/
"Stephane P" wrote:
Hi,
I have made a form with a calendar and want to show the form when cell
"D3" is selected on a particular worksheet. Is there a straight forward way
to do this?
--
Thanks
Stephane