data object / text box integration

  • Thread starter Thread starter Matthew Dyer
  • Start date Start date
M

Matthew Dyer

I have a data object (myData). I am trying to import this information into a text box (results) in my worksheet (sheet2) but running into problems with type mismatch errors and the such. How to I get the information from myData into Results?
 
I have a data object (myData). I am trying to import this information into a text box (results) in my worksheet (sheet2) but running into problems with type mismatch errors and the such. How to I get the information from myData into Results?
Click to expand...

So I was able to find a possible solution. Declairing a string variable (mystr) and setting the value for it with mystr = myData.GetText - now the problem i'm coming across is instead of vbnewline placing a 'carriage' in mystring i am getting the paragraph charachter in my text box. How do i fix this?
 
OK, figured it out. Had to change the properties of my text box to allow multilines. This may help someone else out!!
 
Back
Top