Hi,
I've 3 combobox each one with many values.
After done the selection how can I calculate the maximum of those 3 values?
Thanks
Hi,
I've 3 combobox each one with many values.
After done the selection how can I calculate the maximum of those 3 values?
Thanks
What type of combobox? Data validation list? ActiveX control?
If they are ActiveX you can use something like:
Sub test() MsgBox Application.WorksheetFunction.Max(ComboBox1.Value, ComboBox2.Value, ComboBox3.Value) End Sub
Last edited by Solus Rankin; 12-17-2013 at 12:32 PM.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clicking below their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Here is the solution:
WorksheetFunction.Max(Val(ComboBox1.Value), Val(ComboBox2.Value), Val(ComboBox3.Value))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks