P
Patrick C. Simonds
On my UserForm is a TextBox which gets populated during the UserForm
Initialization and it displays in the ddd dd mmm yy format (see first
set of code) this is so it is easier for the user when talking to the client
because they can refer to the day of the week. Some times they have to edit
the text entering the date as mm/dd/yy but when the value gets copied to the
cell a totally different date is displayed. Any thoughts?
TextBox7.Value = rng(1, 17) ' Date
of 1st Additional Contact Attempt
Me.TextBox7.Value = Format$(TextBox7.Value, "ddd dd mmm yy")
rng(1, 17) = Format(Mid(TextBox7.Value, 5), "mm/dd/yy") '1st Attemp Date
rng(1, 18).Value = TextBox6.Text '1st Attemp Time
Initialization and it displays in the ddd dd mmm yy format (see first
set of code) this is so it is easier for the user when talking to the client
because they can refer to the day of the week. Some times they have to edit
the text entering the date as mm/dd/yy but when the value gets copied to the
cell a totally different date is displayed. Any thoughts?
TextBox7.Value = rng(1, 17) ' Date
of 1st Additional Contact Attempt
Me.TextBox7.Value = Format$(TextBox7.Value, "ddd dd mmm yy")
rng(1, 17) = Format(Mid(TextBox7.Value, 5), "mm/dd/yy") '1st Attemp Date
rng(1, 18).Value = TextBox6.Text '1st Attemp Time