Thread: Pass date to cell in spreadsheet
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
cedtech23[_10_] cedtech23[_10_] is offline
external usenet poster
  
Posts: 1
Default Pass date to cell in spreadsheet

I change the code to


Code:
--------------------

CellPosition.Value = CDate(frmWorkHistory.txtStartMonth.Value & "/31/" & frmWorkHistory.txtStartYear.Value)

--------------------


and I got "run time error '13' type mismatch

since the CDate function converts a value to a date.
is it possible that "/31/" is causing this error??


--
cedtech23
------------------------------------------------------------------------
cedtech23's Profile: http://www.excelforum.com/member.php...o&userid=31022
View this thread: http://www.excelforum.com/showthread...hreadid=507527

Reply With QuoteReply With Quote