ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Activating a Userform in VB when changing Cells in Excel (https://www.excelbanter.com/excel-programming/302875-activating-userform-vbulletin-when-changing-cells-excel.html)

CTInt04

Activating a Userform in VB when changing Cells in Excel
 
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.

Bob Phillips[_6_]

Activating a Userform in VB when changing Cells in Excel
 
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.




All times are GMT +1. The time now is 11:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com