I would like to create an array from the userform input of the TextBoxes. However, I get an error message (Type mismatch (Error 13)) when I want to convert the values from the userform TextBox into the number type clng or cdate
Can someone tell me what I am doing wrong? My array looks like this:
mFields = Array( _
Array(CStr(TextBox1), 2, vbString, "R", 0), _
Array(CStr(TextBox2), 3, vbString, "R", 0), _
Array(CDate(TextBox3), 3, vbString, "R", 0), _
Array(CLng(TextBox4), 4, vbLong, "R", 100))
many thanks!!
Can someone tell me what I am doing wrong? My array looks like this:
mFields = Array( _
Array(CStr(TextBox1), 2, vbString, "R", 0), _
Array(CStr(TextBox2), 3, vbString, "R", 0), _
Array(CDate(TextBox3), 3, vbString, "R", 0), _
Array(CLng(TextBox4), 4, vbLong, "R", 100))
many thanks!!