Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I call a method in VB from Excel with JUST code?
By "method" do you mean a method of a particular object? Or do you just mean
"run a piece of code I wrote"? If the former, I don't see how you would specify the specific object you are referring to nor be able to deal with all the possible return values. If the second, you are just talking about a standard user function: write a Public Function abc() and you can use it in a worksheet cell. "Doseeson" wrote: I want to call a piece of code from VB while I'm in Excel, but here's the tricky part, I don't want to use buttons or any graphical interface. I just want to be able to call the functionality of a piece of code from a cell with just formulas. Something like "=abc()" to run the code in method "abc" Is that possible? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel code to call a macro when a certain value in a cell isselected. | Excel Worksheet Functions | |||
Can you call a Web Service from Excel 2007 without writing code? | Excel Discussion (Misc queries) | |||
how can i call sub or function in vba code | Excel Discussion (Misc queries) | |||
How To Call VBA Code from Excel 4 Macro | Excel Programming | |||
Why system asks me to save change even after I call save method(VB.NET) | Excel Programming |