Formatting decimal places

[tnapele]

Hello!

I have a excel worksheet that uses Vlookups in the cells of the worksheet to plug data into a userform. The Vlookups get the data from a separate worksheet that has a ton of decimals (ie. 2500.7256416436) but I would like to change specific ones to have 2 decimals and others to have no decimals. Is there a way I can do this?
I have tried to format the excel doc outside of VBA but it just re formats to all the extra numbers when I run the code.
I've tried Me.TextBox2.Value = Format(Me.TextBox1.Value, "0.00") and a few other things in the code but nothing I try seems to be working.
Thanks for any guidance!

 

[braindiesel]

Cell A1 = 2500.7256416436
Cell B1 = =round(A1,0)
Cell B1 Value = 2501
Cell C1 = =Round(A1,2)
Cell C1 Value = 2500.73

Replace ROUND with ROUNDUP or ROUNDDOWN to force the logic, otherwise based on 0.5 or greater math logic

Does this help?

 

[tnapele]

Braindiesel,
This would help but unfortunately the data is being pulled from another source and placed onto an already full worksheet. I was hoping for a code that I could add or find a way to do it within just one cell. I appreciate your help though!

 

[Fluff]

Shouldn't it be

 Me.TextBox2.Value = Format(Me.TextBox2.Value, "0.00")

 

[tnapele]

Fluff,
I tried that in my code but it doesn't seem to be working. Is there a way to format textboxes in userforms? I can format the excel document however I want but then I run my code and my userform always comes up with a lot of decimals. Thanks for your help!

 

[Fluff]

Yes you can format textboxes, exactly as shown.
Do you have any change code for that textbox?

 

[tnapele]

Here is a photo of the userform I have. Data is pulled on to this userform from another excel doc that is monitoring our systems constantly. Then the data from this user form overwrites the data in this worksheet to update it.

 

[tnapele]

I'm not sure what change code is, there are a few codes that the text boxes have

 

[Fluff]

Can you post all the code?

 

[tnapele]

I screenshotted but let me know if you would like the text of any of these! This is anywhere where the code for the "Steam produced" on a specific boiler is located.