I have a worksheet that has some text and formula in a table. I have also
used conditional formatting in the table to give be different colour
depending on the results in some of the cells.

I would like to take the entire table including all the colur formatting and
display if in a User form, is this possible?

I have tried:

myuserform.mytextbox.Value = Workbooks(€œmyWorkbook€�).Range("MyRange").Value

If MyRange equals a single cell then it works fine, but if MyRange covers
more than one cell I get an error €œRun-time error €˜-2147352571 (80020005)
Could not set the Value property. Type mismatch.€�

I also tried:

myuserform.mytextbox.Text = Workbooks(€œmyWorkbook€�).Range("MyRange"). Text

and this does not error, but it only display the first cell in a column of
three values.

In either case all formatting appeared lost as I simply ended up with plain
text in the Userform.

--
Trefor