Mornin.
I have a worksheet with 100+ drop downs. They in turn send a numerical value to a results sheet and are all averaged.
All the combo boxes have either a yes/no or a small/med/large selection.
They all then get a value of either 1,2,3.
Is there any way to change these values to 1-50-100.
The drop downs are populated from the same page they are on. But I never actually applied a value. Excel seemed to give them a 1-2-3 based on how I entered them in the combo box.
Any help would be appreciated. If needed I can upload the form.
Thanks in advance.
J
I have a worksheet with 100+ drop downs. They in turn send a numerical value to a results sheet and are all averaged.
All the combo boxes have either a yes/no or a small/med/large selection.
They all then get a value of either 1,2,3.
Is there any way to change these values to 1-50-100.
The drop downs are populated from the same page they are on. But I never actually applied a value. Excel seemed to give them a 1-2-3 based on how I entered them in the combo box.
Any help would be appreciated. If needed I can upload the form.
Thanks in advance.
J