Activating a Userform in VB when changing Cells in Excel

C

CTInt04

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.
 
B

Bob Phillips

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 said:
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.
 
Top