Hi Guys,
I have been able to successfully concatenate the values of 3 Text Boxes in a user form and place them in a dedicated cell in another spreadsheet as alluded to below.
textbox1=0412, textbox2=123, and textbox3=678
Sheet("sheetname") Cell( "L9")= 0412-123-678
I would like to be able to take the value in this cell and repopulate the pertinent text box in the User form.
The textbox1.value, textbox2.value, and textbox3.value have all been concatenated in worksheet("sheetname")Cell ("L9)".
I now wish to be able to use the, left((L9),4) , Mid((L9),6,3) and right((L9),3) to provide the values for textbox1, textbox2 and textbox3 in that order.
Can anyone please help me or am I expecting too much from good old Excel.
I am using Excel 2010 for this project.
Thank you all in advance.