Responded to yesterday's same question.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"CTInt04" wrote in message
...
How do I make a userform appear by changing the cell contents in Excel? I
need to do this without using any command buttons or other VB objects, just
by changing the cell value.