ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   VBA function Procedures.... (https://www.excelbanter.com/excel-worksheet-functions/189762-vba-function-procedures.html)

Arif[_2_]

VBA function Procedures....
 
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

VBA function Procedures....
 
On Tue, 3 Jun 2008 02:44:34 -0700, "Arif" wrote:

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


All times are GMT +1. The time now is 04:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com