Calling VBA Functions in Worksheet

kkknie · May 17th, 2002, 07:52 AM

Is there a way to call a VBA function in a worksheet without creating a UDF? I seem to remember seeing it somewhere, but a search yielded nada.

As an example, I'd like to use the InstrRev function on a cell without having to write code. I'm personally very comfortable with code, but many of the folks I advise are not.

Just asking,

K

Joe Was · May 17th, 2002, 11:41 AM

In the personal.xls or the default workbook(Book1.xls) add your UDF and save. You will now have this function in all future workbooks, without re-typing or copy. Hope this helps. JSW

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 17th, 2002, 07:52 AM	#1
kkknie Board Regular Join Date: Apr 2002 Location: Greenwood, SC Posts: 677	Is there a way to call a VBA function in a worksheet without creating a UDF? I seem to remember seeing it somewhere, but a search yielded nada. As an example, I'd like to use the InstrRev function on a cell without having to write code. I'm personally very comfortable with code, but many of the folks I advise are not. Just asking, K

May 17th, 2002, 11:41 AM	#2
Joe Was MrExcel MVP Join Date: Feb 2002 Location: Central Florida, USA Posts: 7,541	In the personal.xls or the default workbook(Book1.xls) add your UDF and save. You will now have this function in all future workbooks, without re-typing or copy. Hope this helps. JSW