Validation Format

  • Thread starter Thread starter iamnu
  • Start date Start date
I

iamnu

I have a "List" for a Validation field which includes "Done" and "N/
A".

When I select "N/A" from the drop down box, the cell displays "N/a".
"Done" displays "Done"

I have tried just about everything, but I can't get the cell to
properly display the "N/A" Value.

Anyone have a suggestion as to what's wrong?
 
I can't duplicate your problem.

Can you describe *exactly* how you created the drop down list?
 
I have a "List" for a Validation field which includes "Done" and "N/
A".

When I select "N/A" from the drop down box, the cell displays "N/a".
"Done" displays "Done"

I have tried just about everything, but I can't get the cell to
properly display the "N/A" Value.

Anyone have a suggestion as to what's wrong?
Click to expand...

i am also unable to duplicate the issue.
 
i am also unable to duplicate the issue.
Click to expand...

Whoops! What a bozo!

I have discovered that the Workbook has a Workbook_SheetChange
procedure that changes a range of cells to vbProperCase.
The range of cells included those that have the Validation code.

I'm sorry to have taken your time with this, but it did help to tell
me you couldn't duplicate it.

Thanks for your consideration in this matter.
 
Appreciate the feed-back.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

i am also unable to duplicate the issue.
Click to expand...

Whoops! What a bozo!

I have discovered that the Workbook has a Workbook_SheetChange
procedure that changes a range of cells to vbProperCase.
The range of cells included those that have the Validation code.

I'm sorry to have taken your time with this, but it did help to tell
me you couldn't duplicate it.

Thanks for your consideration in this matter.
 
Back
Top