ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using User-Defined Functions in Cells (https://www.excelbanter.com/excel-programming/391222-re-using-user-defined-functions-cells.html)

Trent Argante[_2_]

Using User-Defined Functions in Cells
 
Because you guys told me that Excel doesn't support changing other cells
& manipulating the environment through in-cell formulae, I quit pursuing
that route and solved it through detecting the change via the 'Change'
event, testing the 'Target' parameter and calling my 'PPAPNumber'
function. And, it works!

Thank you guys very much! I was banging my head against the wall.
Aaah, relief; 'tis so sweet.

Trent Argante
[DC.J(510)]

*** Sent via Developersdex http://www.developersdex.com ***


All times are GMT +1. The time now is 05:22 PM.

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