Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox format
Hi
I have the following code to pick up infomation from the spreadsheet and show it in my userform. Dim text1 As Long text1 = UserForm6.TextBox1.Value Range("A4").Select Set material1 = Selection material1.Value = text1 If the number on the spreadsheet is to 2 decimal places the result is rounded, ie 2.72 is shown as 3. Any suggestions to resolve the problem will be gratfully recieved. Regards Oggy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TextBox format? | Excel Discussion (Misc queries) | |||
TextBox format? | Excel Discussion (Misc queries) | |||
textbox format | Excel Programming | |||
TextBox Format | Excel Discussion (Misc queries) | |||
Format Textbox as % | Excel Programming |