I have a drop-down box for a cell. It will convert my selection to a date even though it is not a date. How do you stop it from converting text to date. I set the cell as a text format and it looked fine until I retrieve the data, the cell will populate with my formuala instead of the data as follows:
=IF(VLOOKUP(R[-13]C[-5],Order_DataRange,26,false)=0,"",VLOOKUP(R[-13]C[-5],Order_DataRange,26,false))
Here is a sample of the code that retrieves the saved data:
Range("N15").Select
ActiveCell.FormulaR1C1 = _
"=IF(VLOOKUP(R[-13]C[-5],Order_DataRange,26,false)=0,"""",VLOOKUP(R[-13]C[-5],Order_DataRange,26,false))"
Range("N15").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
=IF(VLOOKUP(R[-13]C[-5],Order_DataRange,26,false)=0,"",VLOOKUP(R[-13]C[-5],Order_DataRange,26,false))
Here is a sample of the code that retrieves the saved data:
Range("N15").Select
ActiveCell.FormulaR1C1 = _
"=IF(VLOOKUP(R[-13]C[-5],Order_DataRange,26,false)=0,"""",VLOOKUP(R[-13]C[-5],Order_DataRange,26,false))"
Range("N15").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False