UDF Help/Comment

[OE]

I used to be able to enter UDF instructions from the VBA environment as
follows;
with cursor in some code, hit F2 to bring up the object browser, select your
library, select your UDF, right click, select Preferences and enter your
instructions in the Description box.
However, entered text is not saved.

Can anone advise?

(The workaround via the GDI works most of the time.)

[Bob Phillips]

It is in mine XL 2002 Win XP.

--
HTH

Bob Phillips

"OE" <[email protected]> wrote in message
news:[email protected]...
> I used to be able to enter UDF instructions from the VBA environment as
> follows;
> with cursor in some code, hit F2 to bring up the object browser, select
your
> library, select your UDF, right click, select Preferences and enter your
> instructions in the Description box.
> However, entered text is not saved.
>
> Can anone advise?
>
> (The workaround via the GDI works most of the time.)

[OE]

I have both versions of Excel also (work / home), the problem is in both.

"Bob Phillips" wrote:

> It is in mine XL 2002 Win XP.
>
> --
> HTH
>
> Bob Phillips
>
> "OE" <[email protected]> wrote in message
> news:[email protected]...
> > I used to be able to enter UDF instructions from the VBA environment as
> > follows;
> > with cursor in some code, hit F2 to bring up the object browser, select
> your
> > library, select your UDF, right click, select Preferences and enter your
> > instructions in the Description box.
> > However, entered text is not saved.
> >
> > Can anone advise?
> >
> > (The workaround via the GDI works most of the time.)
>
>
>

[Bob Phillips]

With these two problems it sounds like you have another problem causing it.

--
HTH

Bob Phillips

"OE" <[email protected]> wrote in message
news:[email protected]...
> I have both versions of Excel also (work / home), the problem is in both.
>
> "Bob Phillips" wrote:
>
> > It is in mine XL 2002 Win XP.
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > "OE" <[email protected]> wrote in message
> > news:[email protected]...
> > > I used to be able to enter UDF instructions from the VBA environment
as
> > > follows;
> > > with cursor in some code, hit F2 to bring up the object browser,
select
> > your
> > > library, select your UDF, right click, select Preferences and enter
your
> > > instructions in the Description box.
> > > However, entered text is not saved.
> > >
> > > Can anone advise?
> > >
> > > (The workaround via the GDI works most of the time.)
> >
> >
> >

[Dave Peterson]

Did you remember to save that workbook with the UDF?

OE wrote:
>
> I used to be able to enter UDF instructions from the VBA environment as
> follows;
> with cursor in some code, hit F2 to bring up the object browser, select your
> library, select your UDF, right click, select Preferences and enter your
> instructions in the Description box.
> However, entered text is not saved.
>
> Can anone advise?
>
> (The workaround via the GDI works most of the time.)

--

Dave Peterson

[OE]

The UDF was in Personal.xls (hidden) but after Unhide the problem remains.
Have given up, will use the GDI backdoor method. But thanks for all thoughts.

"Dave Peterson" wrote:

> Did you remember to save that workbook with the UDF?
>
> OE wrote:
> >
> > I used to be able to enter UDF instructions from the VBA environment as
> > follows;
> > with cursor in some code, hit F2 to bring up the object browser, select your
> > library, select your UDF, right click, select Preferences and enter your
> > instructions in the Description box.
> > However, entered text is not saved.
> >
> > Can anone advise?
> >
> > (The workaround via the GDI works most of the time.)
>
> --
>
> Dave Peterson
>

[Dave Peterson]

Just an aside...Personally, I think going through Excel's GUI is much easier (to
explain and to do). I wouldn't have called it the workaround or backdoor.





OE wrote:
>
> The UDF was in Personal.xls (hidden) but after Unhide the problem remains.
> Have given up, will use the GDI backdoor method. But thanks for all thoughts.
>
> "Dave Peterson" wrote:
>
> > Did you remember to save that workbook with the UDF?
> >
> > OE wrote:
> > >
> > > I used to be able to enter UDF instructions from the VBA environment as
> > > follows;
> > > with cursor in some code, hit F2 to bring up the object browser, select your
> > > library, select your UDF, right click, select Preferences and enter your
> > > instructions in the Description box.
> > > However, entered text is not saved.
> > >
> > > Can anone advise?
> > >
> > > (The workaround via the GDI works most of the time.)
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson

[Matuna]

Hi all,

I know this is a really old post but I couldn't find info on this problem anywhere else. So just in case anyone else is experiencing the same issue.

I was fighting this same problem and was getting pretty frustrated but I finally got it to work.

I closed the window where the udf was written, then went to the object browser, entered the description and it saved.

gday