Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
View Numbers in Textbox in Proper Format in UserForm
Hi, I have one Userform having Textbox2 to show the Value of the Total amount from the worksheet. I mean in Sheet1, B3 there is written 34,540.00 and I want to show this value exactly in UserForm, I connected to the textbox2 in UserForm, but my problem is this, it is showing like this 34540.00 this is not proper format. it should be 34,540.00 (with comma). Kindly advise me how fix this problem. Thanks and regards. Shahzad Madinah |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
View Numbers in Textbox in Proper Format in UserForm
Hi Shahzad4u,
Try using the TextBox's Text property, rather than its value property. Therfore, try, for example, somthing like: '========= Private Sub UserForm_Initialize() Dim WB As Workbook Dim SH As Worksheet Set WB = thisworkboook Set SH = WB.Sheets("Sheet1") '<<==== CHANGE Me.TextBox1.Value = ActiveSheet.Range("A1").Text End Sub '<<========= --- Regards. Norman wrote in message ... Hi, I have one Userform having Textbox2 to show the Value of the Total amount from the worksheet. I mean in Sheet1, B3 there is written 34,540.00 and I want to show this value exactly in UserForm, I connected to the textbox2 in UserForm, but my problem is this, it is showing like this 34540.00 this is not proper format. it should be 34,540.00 (with comma). Kindly advise me how fix this problem. Thanks and regards. Shahzad Madinah |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How2 accept only numbers in userform textbox | Excel Programming | |||
Format TextBox on UserForm | Excel Programming | |||
Max numbers of characters in userform textbox and cell | Excel Programming | |||
format textbox in userform | Excel Programming | |||
Format of a TextBox in a userform | Excel Programming |