HOW TO POPUP A AUTOMATIC CYLINDER IMAGE IS CREATED IN EXCEL

%3CLINGO-SUB%20id%3D%22lingo-sub-3180184%22%20slang%3D%22en-US%22%3EHOW%20TO%20POPUP%20A%20AUTOMATIC%20CYLINDER%20IMAGE%20IS%20CREATED%20IN%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3180184%22%20slang%3D%22en-US%22%3E%3CP%3EHere%26nbsp%3B%20i%20am%20attached%20a%20excel%20sheet%3C%2FP%3E%3CP%3Ehow%20to%20create%20a%20cylinder%20automatically%20when%20enter%20the%20diameter%20and%20height.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ajmalpottekattilyoousuf_0-1645119412748.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F349128iE2FDC8598624D0A9%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22ajmalpottekattilyoousuf_0-1645119412748.png%22%20alt%3D%22ajmalpottekattilyoousuf_0-1645119412748.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3180184%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3180690%22%20slang%3D%22en-US%22%3ERe%3A%20HOW%20TO%20POPUP%20A%20AUTOMATIC%20CYLINDER%20IMAGE%20IS%20CREATED%20IN%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3180690%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156901%22%20target%3D%22_blank%22%3E%40ajmal%20pottekattil%20yoousuf%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20mean%20how%20to%20calculate%20cylinder%20volume%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DPI()*height*diameter%5E2%2F4%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3185729%22%20slang%3D%22en-US%22%3ERe%3A%20HOW%20TO%20POPUP%20A%20AUTOMATIC%20CYLINDER%20IMAGE%20IS%20CREATED%20IN%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3185729%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUser%20Enter%20The%20Height%20and%20Diameter%20in%20Excel%20column%20this%20type%20image%20is%20populated%20automatically%2C%20and%20label%20the%20height%20and%20diameter%20in%20the%20corresponding%20%22h%22%20and%20%22d%22%3C%2FP%3E%3CP%3EThe%20in%20the%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ajmalpottekattilyoousuf_0-1645209789379.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F349541i72412C779548E4FA%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22ajmalpottekattilyoousuf_0-1645209789379.png%22%20alt%3D%22ajmalpottekattilyoousuf_0-1645209789379.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Here  i am attached a excel sheet

how to create a cylinder automatically when enter the diameter and height.

 

ajmalpottekattilyoousuf_0-1645119412748.png

 

2 Replies

@ajmal pottekattil yoousuf 

If you mean how to calculate cylinder volume

=PI()*height*diameter^2/4

@Sergei Baklan 

User Enter The Height and Diameter in Excel column this type image is populated automatically, and label the height and diameter in the corresponding "h" and "d"

The in the 

 

ajmalpottekattilyoousuf_0-1645209789379.png