Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make a function change other cells in worksheet
I have placed "=Test(123)" in cell B2. The function is supposed to return
the value 200 in cell B2 and put the value of 100 in cell A1, but instead returns the "#VALUE!" error and does nothing to cell A1. However, when the same function is called from within a sub (Test2), it works properly. How can I get the function to work properly when called from a worksheet? The function and subs appear below: Function Test(X As Double) Application.Worksheets("Sheet1").Cells(1, 1).Value = 100 Test = 200 End Function Sub Test1() 'This shows that the code below works from within a sub initiated by a command ' button Application.Worksheets("Sheet1").Cells(1, 1).Value = 100 End Sub Sub Test2() MsgBox (Test(123)) End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make a worksheet non editable ...even file extension change | Excel Discussion (Misc queries) | |||
IF statement to make cells change shading | Excel Discussion (Misc queries) | |||
How to make IF function not change cell value? | Excel Worksheet Functions | |||
How do i make a change in one worksheet affect the others | Excel Worksheet Functions | |||
How do I make Excel worksheet tabs change appearance when chosen . | Excel Discussion (Misc queries) |