Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Integration between VB and Excel
While attempting to build a dynamic activity calender I have given up o
the "basic" fomulas in Excel because it is only possible to embed up t seven fomulas in one (i.e. I have embedded seven "If...then" formula into one big motherf...). This big fomula is called in an "overview calender and refers to data in another spreadsheet containing detailed calender, and my problem is that I want to be able to proces more than the possible 7-in-1 formula and I figure that the way to d that is to make a loop in VBA. Is it possible to integrate a loop i excel without making it as an "update" macro? So that when I plot dat in the "data" spreadsheet it shows in the general calender without m having to press update? -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Integration between VB and Excel
http://www.cpearson.com/excel/nested.htm
for your specific question, you can create a user defined function that can be used in a worksheet like a built in function. If you represent your dependencies in the function arguments, it will be calculated as appropriate like built in functions. -- Regards, Tom Ogilvy "Kreller " wrote in message ... While attempting to build a dynamic activity calender I have given up on the "basic" fomulas in Excel because it is only possible to embed up to seven fomulas in one (i.e. I have embedded seven "If...then" formulas into one big motherf...). This big fomula is called in an "overview" calender and refers to data in another spreadsheet containing a detailed calender, and my problem is that I want to be able to process more than the possible 7-in-1 formula and I figure that the way to do that is to make a loop in VBA. Is it possible to integrate a loop in excel without making it as an "update" macro? So that when I plot data in the "data" spreadsheet it shows in the general calender without me having to press update?? --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word/Excel Integration Problem | Excel Discussion (Misc queries) | |||
Excel integration with databases | New Users to Excel | |||
Excel & SAP CSV Integration (Chip or someone else) | Excel Programming | |||
Outlook and Excel Integration for Contacts | Excel Programming | |||
Outlook and Excel Integration | Excel Programming |