Working on a spreadsheet where I need drop down lists. I have used Data Validation but the appearance sucks because the text is so small. So I tried using Form Control Combo Box and that is slightly better but still not a lot of text adjusting can be done but formatting sticks.
So I am trying to get ActiveX Combo Box to work and love all the editing you can do but I am stumped at one part....... My list is in $0.50 format and the drop down list is formatted correctly, but once I select the value, what should be $0.50 shows up as 0.5. I have found some links on the web that use VBA to convert values to date formats but nothing on converting to $ format.
Is there anybody out there that can help me on this?
Thanks a lot in advance
So I am trying to get ActiveX Combo Box to work and love all the editing you can do but I am stumped at one part....... My list is in $0.50 format and the drop down list is formatted correctly, but once I select the value, what should be $0.50 shows up as 0.5. I have found some links on the web that use VBA to convert values to date formats but nothing on converting to $ format.
Is there anybody out there that can help me on this?
Thanks a lot in advance
