Created a function, for the personal.xlsb file

[hitbid]

I just started creating some functions, not sure why I ignored this functionality but they are really handy.

I had a very simple one I figured I would just port over to the personal workbook and be able to use, but it seems functions are not as functional as macros, in that I can't access the function outside of the workbook it is located in.

Is there a way around this? How do you access a function in your personal workbook?

 

[Dave Patton]

Excel 2010
	A	B	C
2		105.00	5.00
3
4	My file	T10_1807a	1b
5
1b

Cell Formulas
Range	Formula
C2	=Personal.xlsb!Gste(B2)

With the UDF stored in Personal.xlsb
In order to use the function you have to precede the function name with PERSONAL.XLSB!

 

[hitbid]

Ha, so it does! Thanks Dave.

 

[My Aswer Is This]

Excel 2010

	A	B	C
My file	T10_1807a	1b

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"]105.00[/TD]
[TD="align: right"]5.00[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

1b​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C2[/TH]
[TD="align: left"]=Personal.xlsb!Gste(B2)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



With the UDF stored in Personal.xlsb
In order to use the function you have to precede the function name with PERSONAL.XLSB!

I never have to do it that way. I just enter =something() And yes the function is in my Personal Workbook only