Save you all UDF in madule in xlms file.
you will get the help from excel editor.
On Thu, Jul 28, 2011 at 5:09 PM, Venkat CV wrote:
> Hi Sandeep,
>
> Save your UDF function as a .XLA (or)XLAM and you may open and use it...
>
>
>
> *Best Regards,*
> *Venkat*
> *Chennai*
> On Thu, Jul 28, 2011
Hi Sandeep,
Save your UDF function as a .XLA (or)XLAM and you may open and use it...
*Best Regards,*
*Venkat*
*Chennai*
On Thu, Jul 28, 2011 at 4:13 PM, wrote:
> Hi excel gurus,
>
> I am using excel 2007.I want to give all my custom excel function (UDF) a
> felling like real function can it
Hi excel gurus,
I am using excel 2007.I want to give all my custom excel function (UDF) a
felling like real function can it possible?
I want to show the user all help to be prompt when they select the UDF.
Thanks in advance.
Sandeep Kr. Chhajer.
Sent on my BlackBerry® from Vodafone
--
I'm attempting a function that has a loop within a loop, to iterate an
optimal value. I'm not seeing why it's not calculating. It returns
#value!
On spreadsheet, the following cashflow
100
-500
1500
-600
Option Explicit
Option Base 1
Public Function OptimalF(ByVal MyCells As Double) As Double
Sorry I didn't get back to you earlier.. I had to scrap this approach
as it wasn't going to work in the long run. Requirements changed,
actually, it's a bit of scope creep, but c'est la vie.
On Oct 11, 10:47 am, Paul Schreiner wrote:
> How are you calling thefunction?
>
> I copied yourfunctionto
Sent: Mon, October 11, 2010 9:49:14 AM
> Subject: $$Excel-Macros$$ Custom Function with UserForm
>
> I have a simple function that looks at a single cell for it's value.
> If it's an X, then i'd like for a form to appear. I'd like to pass
> the value rng.ro
I have a simple function that looks at a single cell for it's value.
If it's an X, then i'd like for a form to appear. I'd like to pass
the value rng.row to the form so I can know which row I'm
manipulating. I've failed so far in my attempts to do just that. Any
tips would be awesome.
Function
I've put this function into my Excel file, in the VBA section.
I've put it in the Personal.xls Module 1. The worksheet itself. A new
Module within the workbook. I've put it everywhere but it doesn't
work. I cribbed it from the internet and it's meant to bring back the
colour / color value of the
Hi!
I need to create a function to define a color of a cell depending on
the value of other.
PRobably this can be achieved using Conditional Formatting, but
actually I need to create a function for example
=cellcolor(Red,referenced cell)
Anyone can help me with this function?
Thanks!
Zek
--
