| Home |
| Search |
| Today's Posts |
|
#11
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Functions in VBA used in spreadsheet cell
Thank you,
JRXPL "Gord Dibben" wrote: One more time.................. With your workbook open, hit Alt + F11 to open the Visual Basic Editor window. CTRL + r to open the Project Explorer. DO NOT doubleclick on anything!! Right-click on your workbook(project) and InsertModule. Paste this into that module........... Function CalculateOne(a, b) CalculateOne = a + b End Function FileSave the workbook. Alt + q to return to Excel window. In any cell enter =Calculateone(2,3) which returns 5 Make sure you have ToolsOptionsCalculation set to "Automatic" Gord On Sun, 20 Apr 2008 11:54:00 -0700, JRXPL wrote: Thanks for the info everyone, reading over the posts, I tried to create a new Module and inserted the Function code and it works in this manner. I am unable to get it to work in the code area for (General) or the code area for Worksheet when I dblclick on the worksheet or the code area for Workbook when I dblclick on the project. Sorry for the misunderstanding, but is this the way it is suppose to work? I feel like I am missing a basic concept. I have tried this on two different computer systems. Thanks again. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel spreadsheet print functions | Excel Worksheet Functions | |||
| 8 Functions in a spreadsheet program | Excel Discussion (Misc queries) | |||
| Spreadsheet functions | Excel Discussion (Misc queries) | |||
| Functions not working in Spreadsheet | Excel Worksheet Functions | |||
| Spreadsheet functions | Excel Worksheet Functions | |||
Threaded Mode
