Adjust code to cater for multiple combo boxes

[sueanne]

Hi,

I am having great difficulty trying to work out how to calculate GST on a userform. I apologise for the duplicate post, however the other post probably didn't explain it very well.

I have managed to get the code below to work for cboTax1 however I cannot work out how to adjust this code to cater for multiple combo boxes.
By that I mean, I have cboTax1-10 and I need to perform this calculation for all 10 boxes and put the total of the results to Taxamt Textbox.

Private Sub cboTax1_change()
If cboTax1.Value = "GST Free" Then
 Taxamt1 = "$0.00"
Else
Taxamt1 = (Total1.Value * (10 / 100))
 End If
Taxamt.Value = Format(Taxamt1, "$#,##0.00")
 End Sub

If anyone can please help that would be greatly appreciated, I have been searching the net for days now, but just cant find anything that works for what I want. Maybe I cant do it how I want? 

Thanks so much!
Sue-Anne

 

[sueanne]

I have found a couple of things that are not quite working, here is a summary below. I am still working on these however I haven't had any luck so far;
a) Total calculation is not deducting the discount as a percentage, it is deducting it as a number. ie 1% as 1, 2% as 2
b) You can enter in a unit price as 56.30 (without the $ sign, if you enter with a $ sign, then total doesn't have a $ sign), however the total doesn't calculate with the cents, only the dollars. It shows up as $56.00 but not $56.30
c) The unit price field can have text or numbers in it, I want to limit it to numerical only and a warning pop up if not numerical (similar to one with Qty)

Thanks again for all your help!

 

[pike]

pity you haven't shared the workbook so everyone could help

 

[sueanne]

Hi pike,

I don't have permissions to attach it on the forum as far as I can see. More than happy to share so people can help, do you know how I can do this? I appreciate all the help I can get

 

[pike]

reply to thread > Go advanced > manage attachments

 

[sueanne]

Hi pike & hippiehacker,

Thank you both for your assistance, I have managed to get these issues resolved. All time and efforts are much appreciated.

 

[hippiehacker]

good that you figured it out