to roundoff the digits for display in textbox of userform

**taniks** · 01-21-2009, 08:35 AM

I am trying to display the results that i get in excel sheet in a userform using textboxes;

I need to round off the digits in these textboxes so as to display 2 digits after decimal point!

I would like to have the code to solve this problem!

thanks a lot for ur time!

Taniks

**royUK** · 01-21-2009, 08:39 AM

Try

Please Login or Register  to view this content.

**taniks** · 01-21-2009, 10:13 AM

I am using a french version of MS office!

actually this is my code for the text box value.

<txtconsohp.Value = Sheets("calcul conso ").Range("Q62").Value>

could u just give me code for this particular text box value!

thanks a lot

Taniks

**royUK** · 01-21-2009, 10:24 AM

Try

Please Login or Register  to view this content.

**taniks** · 01-21-2009, 10:54 AM

Thanks a lot for ur kind help!

Regards
Taniks

to roundoff the digits for display in textbox of userform

LinkBack

Thread Tools

Rate This Thread

Display

to roundoff the digits for display in textbox of userform

french version

The code works

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions