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!

 

[tnapele]

We also have a vlookup in the worksheet itself which is: =(VLOOKUP(A192,'\\192.168.28.60\pasdas\Reports\[2020PasDasCitectDataCollectionDaily.xlsm]B1Data'!$A$1:$IV$371,251))

I also want to add that I did not create this file or do very much of the coding for it, but as an intern I'm tasked with figuring out how to update it. I appreciate your help!!

 

[Fluff]

None of that code is formatting a textbox.

 

[tnapele]

I wasn't sure you could use code to format a textbox. How would I format a text box to allow only 2 decimal places?

 

[Fluff]

As I showed in post#4

 

[tnapele]

When I tried that it didn't seem to work. Is there a spot in the code that you think it would work better or does it not matter about placement?

 

[Fluff]

Did you change the Textbox names to match your textboxes?
Please post the code that you are using, including how you populate the textbox initially.