Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using a VB function in a spreeadsheet
I opened the VB editor and added a simple function to the General sheet. I
tried both ThisWorkbook and the specific sheet. Public Function Ripple(x As Double) As Double Ripple = x End Function In the spreadsheet I try to put =Ripple(A1), etc, into cells, but I get a #Name? error. How do I get the spreadsheet to recognize the VB function? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
using a VB function in a spreeadsheet
You have to plce your code in a Module.
-- AP "Bill Brehm " <<don't want any spam a écrit dans le message de ... I opened the VB editor and added a simple function to the General sheet. I tried both ThisWorkbook and the specific sheet. Public Function Ripple(x As Double) As Double Ripple = x End Function In the spreadsheet I try to put =Ripple(A1), etc, into cells, but I get a #Name? error. How do I get the spreadsheet to recognize the VB function? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
using a VB function in a spreeadsheet
I tried that and I still get the #Name? error. I have hit F9 to recalculate.
As a test I added two Ripple functions and when I added a new cell with that name it popped up an error the notice the name conflict. So it seems to be trying. Any other suggestion? "Ardus Petus" wrote in message ... You have to plce your code in a Module. -- AP "Bill Brehm " <<don't want any spam a écrit dans le message de ... I opened the VB editor and added a simple function to the General sheet. I tried both ThisWorkbook and the specific sheet. Public Function Ripple(x As Double) As Double Ripple = x End Function In the spreadsheet I try to put =Ripple(A1), etc, into cells, but I get a #Name? error. How do I get the spreadsheet to recognize the VB function? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
using a VB function in a spreeadsheet
Works by me.
see example: http://cjoint.com/?dqjN3isIYk HTH -- AP "Bill Brehm " <<don't want any spam a écrit dans le message de ... I tried that and I still get the #Name? error. I have hit F9 to recalculate. As a test I added two Ripple functions and when I added a new cell with that name it popped up an error the notice the name conflict. So it seems to be trying. Any other suggestion? "Ardus Petus" wrote in message ... You have to plce your code in a Module. -- AP "Bill Brehm " <<don't want any spam a écrit dans le message de ... I opened the VB editor and added a simple function to the General sheet. I tried both ThisWorkbook and the specific sheet. Public Function Ripple(x As Double) As Double Ripple = x End Function In the spreadsheet I try to put =Ripple(A1), etc, into cells, but I get a #Name? error. How do I get the spreadsheet to recognize the VB function? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
using a VB function in a spreeadsheet
Strange. You are right. Mine doesn't work but yours does. I just deleted
mine and renamed yours and I am happy. Thanks. "Ardus Petus" wrote in message ... Works by me. see example: http://cjoint.com/?dqjN3isIYk HTH -- AP "Bill Brehm " <<don't want any spam a écrit dans le message de ... I tried that and I still get the #Name? error. I have hit F9 to recalculate. As a test I added two Ripple functions and when I added a new cell with that name it popped up an error the notice the name conflict. So it seems to be trying. Any other suggestion? "Ardus Petus" wrote in message ... You have to plce your code in a Module. -- AP "Bill Brehm " <<don't want any spam a écrit dans le message de ... I opened the VB editor and added a simple function to the General sheet. I tried both ThisWorkbook and the specific sheet. Public Function Ripple(x As Double) As Double Ripple = x End Function In the spreadsheet I try to put =Ripple(A1), etc, into cells, but I get a #Name? error. How do I get the spreadsheet to recognize the VB function? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
using a VB function in a spreeadsheet
I was having the same problem but only when I placed the function in
Personal.xls. When I placed the same function in a module in the workbook that I wanted to use it in, it worked fine. Dunno if you've already tried this?! "Ardus Petus" wrote: Works by me. see example: http://cjoint.com/?dqjN3isIYk HTH -- AP "Bill Brehm " <<don't want any spam a écrit dans le message de ... I tried that and I still get the #Name? error. I have hit F9 to recalculate. As a test I added two Ripple functions and when I added a new cell with that name it popped up an error the notice the name conflict. So it seems to be trying. Any other suggestion? "Ardus Petus" wrote in message ... You have to plce your code in a Module. -- AP "Bill Brehm " <<don't want any spam a écrit dans le message de ... I opened the VB editor and added a simple function to the General sheet. I tried both ThisWorkbook and the specific sheet. Public Function Ripple(x As Double) As Double Ripple = x End Function In the spreadsheet I try to put =Ripple(A1), etc, into cells, but I get a #Name? error. How do I get the spreadsheet to recognize the VB function? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
using a VB function in a spreeadsheet
No I hadn't put it in personal.xls. I first started out putting it in
Microsoft Excel Objects, Sheet1 and ThisWorkbook. Then at Ardus Petus suggestion I put it in Modules, Module1 but it still didn't work. Just now I started over from scratch and it works fine. So I guess putting it in the wrong place caused me some trouble. "piyush1982" wrote in message ... I was having the same problem but only when I placed the function in Personal.xls. When I placed the same function in a module in the workbook that I wanted to use it in, it worked fine. Dunno if you've already tried this?! "Ardus Petus" wrote: Works by me. see example: http://cjoint.com/?dqjN3isIYk HTH -- AP "Bill Brehm " <<don't want any spam a écrit dans le message de ... I tried that and I still get the #Name? error. I have hit F9 to recalculate. As a test I added two Ripple functions and when I added a new cell with that name it popped up an error the notice the name conflict. So it seems to be trying. Any other suggestion? "Ardus Petus" wrote in message ... You have to plce your code in a Module. -- AP "Bill Brehm " <<don't want any spam a écrit dans le message de ... I opened the VB editor and added a simple function to the General sheet. I tried both ThisWorkbook and the specific sheet. Public Function Ripple(x As Double) As Double Ripple = x End Function In the spreadsheet I try to put =Ripple(A1), etc, into cells, but I get a #Name? error. How do I get the spreadsheet to recognize the VB function? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |