VBA function Procedures....

[Arif]

hi,
Thanks for reply... I am asking where you write function... in the names
cell or create special module like .. we do in Access.
on the Ribbon I dont see.. any hint ..

thanks

will appreciate reply.. A. Khalak

 

[Ron Rosenfeld]

hi,
Thanks for reply... I am asking where you write function... in the names
cell or create special module like .. we do in Access.
on the Ribbon I dont see.. any hint ..

thanks

will appreciate reply.. A. Khalak

Please keep your messages in a single thread if they are referring to the same
topic.

Are you asking how to have something on the ribbon to let you access the VBA
Editor in Excel?

If that is your question, select:
Office Button
Excel Options
Popular
Top options for working with Excel
SELECT "Show Developer tab in the Ribbon

Or, you can use the shortcut key <alt-F11>

Or, you can right click on the sheet tab and select 'View Code'.

However you get there, you will need to Insert/Module to insert a regular
module for a UDF.
--ron