Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array activation question
Morning all.
I'm making a user form to simplify the input of data for a complicated worksheet function. One of the things I was told about this function is that it requires a specific key combination-- ctrl+shift+enter, with the cell being active (the cursor needs to be active within the cell field, or the formula bar). Apparently this places two {} on the outsides of the equation, to do something to it that makes it work. And it's not enough to just place the {} on the equation manually. It specifically requires the keystroke combination mentioned above. My question--- Within the workings of the wizard/userform that I'm making, can I do something to activate this set up so that once the wizard/form is finished, the formulas are actively working? I hope this is clear-- if not, please let me know. Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array activation question
On Wed, 6 Jan 2010 09:18:01 -0800, Steve
wrote: Morning all. I'm making a user form to simplify the input of data for a complicated worksheet function. One of the things I was told about this function is that it requires a specific key combination-- ctrl+shift+enter, with the cell being active (the cursor needs to be active within the cell field, or the formula bar). Apparently this places two {} on the outsides of the equation, to do something to it that makes it work. And it's not enough to just place the {} on the equation manually. It specifically requires the keystroke combination mentioned above. My question--- Within the workings of the wizard/userform that I'm making, can I do something to activate this set up so that once the wizard/form is finished, the formulas are actively working? I hope this is clear-- if not, please let me know. Thank you. Try this statement in your code:: Worksheets("Sheet1").Range("A1").FormulaArray ="=your formula here" Change the sheet name and range to suit your needs. Hope this helps / Lars-Åke |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array activation question
Assign the final formula string with FormulaArray rather than Formula:
Range("A1").FormulaArray = "your formula" Cordially, Chip Pearson Microsoft MVP 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com [email on web site] On Wed, 6 Jan 2010 09:18:01 -0800, Steve wrote: Morning all. I'm making a user form to simplify the input of data for a complicated worksheet function. One of the things I was told about this function is that it requires a specific key combination-- ctrl+shift+enter, with the cell being active (the cursor needs to be active within the cell field, or the formula bar). Apparently this places two {} on the outsides of the equation, to do something to it that makes it work. And it's not enough to just place the {} on the equation manually. It specifically requires the keystroke combination mentioned above. My question--- Within the workings of the wizard/userform that I'm making, can I do something to activate this set up so that once the wizard/form is finished, the formulas are actively working? I hope this is clear-- if not, please let me know. Thank you. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array activation question
Ok, since you both replied with the same thing, I'll need to read more on
this topic. So, .formulaArray does what I want...... Thank you. Will let you know if I have any further questions on it. Thanks-- both of you. "Chip Pearson" wrote: Assign the final formula string with FormulaArray rather than Formula: Range("A1").FormulaArray = "your formula" Cordially, Chip Pearson Microsoft MVP 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com [email on web site] On Wed, 6 Jan 2010 09:18:01 -0800, Steve wrote: Morning all. I'm making a user form to simplify the input of data for a complicated worksheet function. One of the things I was told about this function is that it requires a specific key combination-- ctrl+shift+enter, with the cell being active (the cursor needs to be active within the cell field, or the formula bar). Apparently this places two {} on the outsides of the equation, to do something to it that makes it work. And it's not enough to just place the {} on the equation manually. It specifically requires the keystroke combination mentioned above. My question--- Within the workings of the wizard/userform that I'm making, can I do something to activate this set up so that once the wizard/form is finished, the formulas are actively working? I hope this is clear-- if not, please let me know. Thank you. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
activation key | Excel Discussion (Misc queries) | |||
Procedure Activation | Excel Programming | |||
Sheet activation | Excel Discussion (Misc queries) | |||
implicit activation | Excel Programming | |||
UserForm Activation | Excel Programming |