Reply to thread

Message: [QUOTE="RyanH, post: 6343161"] When I load the cell value into Textbox1 when the userform is called it looks just like a accounting format, plus if I don't change the text, when I click my "Apply" button in applies the value to the cell just fine. The problem happens when I change the Textbox1 value. I can only add a $ right next to the first number instead of it looking like it has a "Accounting" format. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) frmItemSummary.Textbox1 = Cells(Target.Row, "A") frmItemSummary.Show End Sub Private Sub btnApply_Click() Sheets("Global Schedule").Cells(ActiveCell.Row, "A") = Textbox1 End Sub -- Cheers, Ryan [/QUOTE]