Hi,
I have this userform with 6 ComboBoxes, if combobox has a value it will show "5" on cell H4 and it will add another 5 depending on the combobox that has a value or not empty. If the Combobox is empty it will subtract 5 to cell H4.
Thank you!
Hi,
I have this userform with 6 ComboBoxes, if combobox has a value it will show "5" on cell H4 and it will add another 5 depending on the combobox that has a value or not empty. If the Combobox is empty it will subtract 5 to cell H4.
Thank you!
Last edited by 323100N; 05-25-2018 at 05:21 AM.
Please see attached file
You need to elaborate more because this isn't clear at all.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Sorry for the confusion. If the value of 1 Combobox is not empty cell H4 will add value of 5 and if combobox is empty it will minus or deduct 5 to cell H4. So for every combobox it has a value or amount of 5.
thank you!
Here is the screenshot that i want to achieved. In this screenshot it will shot the total of 25 because all of the combobox has a value, then for instances that 1 combobox has no value it will minus 5 so the total price will be 20. Thank you!
re-upload the screenshot
any help please?
323100N,
Maybe the attached file could help you on the right track.
Check the userform1 and code added to the comboboxes.
krgds,
Mario
Hi MarMo this is perfect. Thank you for your help!
Hi 323100N,
Glad to hear.
If this solved your problem, please change your thread to [SOLVED].
Even a little help can be a big help !!
1. A sample workbook says more then words. Add problem description and solution so we can understand the problem.
2. Your appreciation is accepted by clicking the star "Add Reputation" at the lower left of the post.
3. If your problem is solved, mark it as [SOLVED]: See "FAQ : " https://www.excelforum.com/faq.php
4. Use [CODE] [/CODE] tags to illustrate your code: see here
Sorry one more thing, how to prevent by selecting again the same value of combobox? for example the "fries" was already used it will removed on the selection? thank you
You should then consider checkboxes instead of comboboxes on your userform.
You can only choose the "fries" once, as all of the other ingredients.
It's not impossible to do the comboboxes, but it's more complicated.
Try the checkboxes instead.
See attached file with modified code on the userform.
Krgds
Mario
You have a point with regards on using checkbox. Ill check on this. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks