Using VBA Macro To Calculate Amount in Cell Excel 2010

[sanjay11422]

This is Simple Calculation in Excel 2010 That I Want in My Program I Created Invoice Template But The Problem is I Have To Calculate Multi Tax Rate in Single Cell By Combo-box You Can Batter Understand As Shown in Image Please Help Me Thank You So Much

Untitled.jpg

[mana]

combobox is activeX control?


Linkedcell:C5 <---font color is white
D5 formula:=IFERROR(E4*MID(D3,6,6),"")

[sanjay11422]

Yes Combo-box is activeX control

[mana]

sorry

Linkedcell:C4 <---font color is white
D4 formula:=IFERROR(D3*MID(C4,6,6),"")

[sanjay11422]

No you are not getting me peoperly there is no linked cell its combo-box see the image

[mana]

>there is no linked cell

you can set linkedcell with property window manually

or

Sub test()
    With range("C4")
        ActiveSheet.Shapes("ComboBox1").OLEFormat.Object.LinkedCell = .Address
        .Font.Color = vbWhite
    End With
End Sub

[sanjay11422]

no see image what i want

[mana]

I'm sorry.
I don't think I can understand what you want to do.

[mdmackillop]

As shown