PDA

View Full Version : Using VBA Macro To Calculate Amount in Cell Excel 2010



sanjay11422
07-14-2017, 06:03 PM
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 :banghead::banghead: Thank You So Much :clap::friends:

19752

mana
07-14-2017, 06:51 PM
combobox is activeX control?


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

sanjay11422
07-14-2017, 06:54 PM
Yes Combo-box is activeX control

mana
07-14-2017, 06:55 PM
sorry

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

sanjay11422
07-14-2017, 09:53 PM
No you are not getting me peoperly there is no linked cell its combo-box see the image

mana
07-14-2017, 10:33 PM
>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
07-14-2017, 11:36 PM
no see image what i want

mana
07-15-2017, 04:00 AM
I'm sorry.
I don't think I can understand what you want to do.

mdmackillop
07-15-2017, 04:34 AM
As shown