3D mu Excel

Ngati pa Tsiku la Valentine lomaliza mudapatsa kale mkazi wanu wokondedwa chovala cha ubweya wa cheetah, ndipo chaka chapitacho - iPhone 7, ndipo mukudabwa kuti ndi chiyani chinanso chomwe mungaganizire, ndiye ndikhoza kupereka njira:

Zimatenga mphindi 2 kuchita izi.

Tsegulani Excel, pitani ku tabu Ikani - Mawonekedwe (Ikani - Mawonekedwe) ndi kusankha mtima:

3D mu Excel

Timajambula papepala, lowetsani mawu okhudza mtima mkati, muwapange moyenerera:

3D mu Excel

Kuti mumve zambiri mwachilengedwe, onjezani mawonekedwe a 3D pa tabu Format - Mawonekedwe a Mawonekedwe (Mawonekedwe - Mawonekedwe a Mawonekedwe):

3D mu Excel

Ndipo kukhudza komaliza - onjezerani macro kwa makanema ojambula. Dinani Alt + F11, pawindo la Visual Basic editor lomwe limatsegula, ikani gawo latsopano lopanda kanthu kudzera pa menyu Ikani - Module ndikukopera zolemba za macro apa:

Sub Heart() Kwa i = 1 Mpaka 3000 Ndi ActiveSheet.Shapes.Range(Array("Сердце 1")).ThreeD .RotationX = i .RotationY = i / 20 .RotationZ = i / 2 Malizitsani Ndi Kugwiritsa Ntchito.Dikirani (Tsopano + TimeSerial (0, 0, 0.1)) Kenako ndikumaliza Sub  

Tsekani Visual Basic Editor, dinani Alt + F8 ndikuyendetsa macro athu. Voila! Wokondedwa - mu chisangalalo, inu - mukupsompsona, holide inali yopambana. Ngati wokondedwa wanu sakuyamikira, ndiye kuti phunzirani malamulo a VBA ogwirira ntchito ndi 3D 🙂

 

Siyani Mumakonda