I have a user form that I can copy over to another worksheet.
However, the data is transferring over as text - and I will need to do calculations on the resulting populated data table. I cannot figure out how to set the resulting text/number in the right format.![]()
With DataSH Addme.Offset(0, -1) = DataSH.Range("C6").Value + 1 Addme.Value = Me.cboSubrecipient Addme.Offset(0, 1).Value = Me.txtVIN Addme.Offset(0, 2).Value = Me.cboModelYear
Thanks.
Bookmarks