LinkBack URL
About LinkBacks
I've made a userform that gets at value from a worksheet and at the sam time format it as #,##0. When transfering it back to the worksheet it's textstring but i want it to be a value. Please help
Bengt
I've made a userform that gets at value from a worksheet and at the sam time format it as #,##0. When transfering it back to the worksheet it's textstring but i want it to be a value. Please help
Bengt
Post your code.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Thats my code as an example of my problem. In cell A2 i want a value because, later on I want to sum the column A.
Private Sub UserForm_Initialize() TextBox1.Value = Format(Sheets("Sheet1").Range("A1").Value, "#,##0") End Sub Private Sub CommandButton1_Click() Sheets("Sheet1").Range("A2").Value = TextBox1.Value UserForm1.Hide Unload UserForm1 End Sub
Last edited by Leith Ross; 02-21-2014 at 12:12 PM.
Change to:
Private Sub CommandButton1_Click() Sheets("Sheet1").Range("A2").Value = CDbl(TextBox1.Value) UserForm1.Hide Unload UserForm1 End Sub
Thank You!!!!
That saved me a lot of new gray hair!
Best Regards/Bengt
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks