Office 2007 Loader

Avatar of liacbosenen.
Avatar of liacbosenen.

Office 2007 Loader

Office 2007 Loader

I would like to make a field which allows for a user to type in a date into a textbox and then assign the textbox the date to the proper cell in the day. Example: user types in "12/31/2008" in the textbox and then click assign. The textbox is then assigned to the cell value "30" in cell B2. So far I have this so far: Private Sub TextBox2_Change() Dim MyDate As String MyDate = TextBox2.Text Dim d As Date d = DateValue(MyDate) Range("B2").Value = d End Sub Function DateValue(dt As Date) dt = Format(dt, "mm/dd/yyyy") Select Case Len(dt) Case 1 DateValue = CDbl(dt) Case 2 DateValue = CDbl(dt) * 100 Case 3 DateValue = CDbl(dt) * 1000 Case 4 DateValue = CDbl(dt) * 10000 Case 5 DateValue = CDbl(dt) * 100000 Case 6 DateValue = CDbl(dt) * 1000000 Case 7 DateValue = CDbl(dt) * 10000000 Case 8 DateValue = CDbl(dt) * 100000000 Case Else End Select End Function Unfortunately it's assigning the date as a number instead of the date. Any help would be great, thanks. A: Define: Sub DateValue() Dim dt As Date dt = CDate(TextBox2.Text) Range("B2").Value = dt And use: Private Sub TextBox2_Change


07da50c951











schritte international 3 lehrerhandbuch pdf 11
Formula 1 2009 Pc Game Free Download Full Version
national treasure 3 1080p brrip torrent
Hyundai Modern H Font Download
micro flight 5 keygen torrent

I would like to make a field which allows for a user to type in a date into a textbox and then assign the textbox the date to the proper cell in the day. Example: user types in "12/31/2008" in the textbox and then click assign. The textbox is then as
Avatar of the user.
Please login to comment.

Đã đăng: thg 5 13 2022
30
2
0

Chia sẻ