View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default 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.