threed

Hi dear members. I thought I would post this little project here . Basically, as per the thread title, the code creates beveled round buttons at runtime. The buttons can be added to the userform or to a frame control. Behind the scenes, the code creates temporary round shapes in a hidden...

Hello all, I seem to be having an issue with rotating a 3D surface. I have an grid of elevation values that I have plotted to a 3D surface. I want to be able to use 2 ActiveX spin buttons to rotate the surface in the X and Y planes, in order to get a better look at the surface elevations...

Hello! Running into an issue when trying to create a 3D Sumproduct formula, which I have come to find out is not possible in MS Excel 2010 since the Morefunc add-in is not compatible, to use THREED function. Trying to figure out the work around using a "SUMPRODUCT(N(INDIRECT" function, but...

Here's what is bugging me; have 2 workbooks: 1st is a production lot sheet 2nd is a weekly production planning sheet I want to type in a lot# on 1st workbook and then get all the relevant data from 2nd workbook. 2nd workbook (weekly production planning) has 52 sheets (hence 52 weeks in a...

I am attempting to use conditionally sum across multiple tabs using the "threed' function. What I have found - using the threed function with cell references appears to work. For example this formula proves successful...

Hi everyone, I'm trying to do something that appears rather complicated to me. I'm using an array function (sumproduct) but i need to use 3d references, which arent compatible with some array functions. So, I'm using threed to change a 3d array into a 2d array. This is all to work out how many...