Import Cell format in userform textbox 2

[ckhunley]

I have macro which uses a combobox to filter a database based on criteria in the first column. I want to then pull the info from the remaining columns into text boxes on the user form, so that the user can alter any of the entries (such as number of parts) before I paste that entry into another worksheet. I have been able to pull the text from the appropriate cell, but is there a way to get any associated formatting (such as color, border, etc.) so that it will match up when it is pasted into the new workbook. (I have certain values highlighted in the database which should not generally be changed, and want this to be shown on the userform.)
Thanks
Chris

 

[BrainB]

This uses some cell properties to format a text box :-

Private Sub CommandButton1_Click()
    Dim MyCell As Range
    Set MyCell = ActiveSheet.Range("A1")
    Me.TextBox1.BackColor = MyCell.Interior.Color
    Me.TextBox1.ForeColor = MyCell.Font.Color
    Me.TextBox1.Font.Bold = MyCell.Font.Bold
End Sub

Regards
BrianB
Use CupOfCoffee to speed up all windows applications
================================