Thread: Dates as Numbers in Combo Box
View Single Post
  #2  
Old 09-18-2008, 05:08 AM
rwgrietveld's Avatar
rwgrietveld rwgrietveld is offline
Forum Guru
  
Join Date: 02 Sep 2008
Location: Netherlands
MS Office Version:XL 2007 / XL 2010
Posts: 1,643
rwgrietveld is very confident of their ability rwgrietveld is very confident of their ability rwgrietveld is very confident of their ability rwgrietveld is very confident of their ability rwgrietveld is very confident of their ability
re: Dates as Numbers in Combo Box
Maybe there is a better way but this works:
Code:
cboGetDate.Text = CLng(Format(cboGetDate.Value, "#######"))
__________________
Looking for great solutions but hate waiting?
Seach this Forum through Google

www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )

www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )

Ave,
Ricardo
Reply With Quote