| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Equations to Fill in TextBox
I have a form for data entry with one field in particular that I want
auto-populated based on values throughout this form. To get this value, I use the Enter event in the textbox, but I keep getting Type Mismatch errors when I do txt1.value-txt2.value and so on. Can I sum values from text boxes? -- I am running on Office 2003, unless otherwise stated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using Equations to Fill in TextBox
Yes, but the values have to be numeric.
A textbox contains text. <g Try... CDbl(txt1.Value) + Val(txt2.Value) Either CDbl or Val should work. -- Jim Cone Portland, Oregon USA "Orion Cochrane" wrote in message I have a form for data entry with one field in particular that I want auto-populated based on values throughout this form. To get this value, I use the Enter event in the textbox, but I keep getting Type Mismatch errors when I do txt1.value-txt2.value and so on. Can I sum values from text boxes? -- I am running on Office 2003, unless otherwise stated. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using Equations to Fill in TextBox
That worked beautifully. Thanks. -- I am running on Office 2003, unless otherwise stated. "Jim Cone" wrote: Yes, but the values have to be numeric. A textbox contains text. <g Try... CDbl(txt1.Value) + Val(txt2.Value) Either CDbl or Val should work. -- Jim Cone Portland, Oregon USA "Orion Cochrane" wrote in message I have a form for data entry with one field in particular that I want auto-populated based on values throughout this form. To get this value, I use the Enter event in the textbox, but I keep getting Type Mismatch errors when I do txt1.value-txt2.value and so on. Can I sum values from text boxes? -- I am running on Office 2003, unless otherwise stated. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using Equations to Fill in TextBox
You are welcome and thanks for the update. '-- Jim Cone "Orion Cochrane" wrote in message That worked beautifully. Thanks. -- I am running on Office 2003, unless otherwise stated. "Jim Cone" wrote: Yes, but the values have to be numeric. A textbox contains text. <g Try... CDbl(txt1.Value) + Val(txt2.Value) Either CDbl or Val should work. -- Jim Cone Portland, Oregon USA "Orion Cochrane" wrote in message I have a form for data entry with one field in particular that I want auto-populated based on values throughout this form. To get this value, I use the Enter event in the textbox, but I keep getting Type Mismatch errors when I do txt1.value-txt2.value and so on. Can I sum values from text boxes? -- I am running on Office 2003, unless otherwise stated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Fill Equations in VBA | Excel Programming | |||
| fill userform textbox from userform listbox clik event | Excel Programming | |||
| using a map to fill in a textbox | New Users to Excel | |||
| Match TextBox Back Color to Cell Fill Color | Excel Programming | |||
| Fill Textbox from cell | Excel Programming | |||
Linear Mode
