Problems with excel

[Israel Moreno]

Hi everybody,

My question is this. How i run a visual basic's function in one cell of excel?

Excuseme for my grammar's problem but i spanish.


Thanks.

 

[JulieD]

Hi

if you want the code to run when the value in a cell is changed or meets a
certain criteria you can do this through a worksheet_change event (right
mouse click on the relevant sheet tab and choose view code) e.g.

Private Sub Worksheet_Change(ByVal Target As Range)

application.enableevents = false
on error goto err_handler
if target.address = "$A$1" and target.value = 1 then
'your code here
end if

err_handler:
application.enableevents = true
End Sub
---
this says ... if cell A1 has changed and the value in this cell is 1 run the
code

Hope this helps
Cheers
JulieD

 

[Markus Scheible]

Hi Israel,


if your VBA function is called e.g. "function1()", simply
use

=function1()

as the cell formula and it should work.

Best

Markus