Forum Discussion
Combobox return blank for 1st option
Hi,
I'm creating a non VBA combobox with the 1st option being "Select" as I need an option to have a null value. I'm referencing the combobox in another formula so can't have "Select" return 1. is there any way if the option is set to "Select" for it to return blank or no value?
Thanks in advance.
- HI,
I used =if(b2=”Select”,c1=”Ascending”,c1=”Descending”) and then added a helper row below to filter out the 1 to use in my next formula. Thanks for your help.
- so what about 0? can it return 0?
using custom number formatting you can get cell A1 to SHOW "Select" but have a VALUE of 0
Custom Number Format => 0 ; -0 ; "Select"; @
Then the drop down (at least the one I tested using Data Validation) still showed "Select" but if selected it returns a VALUE of 0
and then you can have that cell use custom number format and not show the 0
Custom Number Format => 0 ; -0 ; ; @ AndyT410 Perhaps in cell C1 you could use =IF(B1=1,"",B1-1), then reference cell C1 instead of B1 in your "other formula".
- HI,
I used =if(b2=”Select”,c1=”Ascending”,c1=”Descending”) and then added a helper row below to filter out the 1 to use in my next formula. Thanks for your help.
