| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Difference between .text and .value of a textbox
Hi
recently I was trying to create a userform where I was giving the valu of text box to a cell. The textbox value was more that 255 chars and used following method. range("A25").value = txtUpdate.value which then I tested I got a result as #Value error in the cell... I changed the code to range("A25").value = txtUpdate.text and it worked.... can somebody tell me the difference between the above 2.. How to make sure a user is entering a plain text value instead o formula in a textbox... Thanx in advance Keda -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How calculate a difference btwn 2 TextBox and insert the result inthe appropriate cell | Excel Discussion (Misc queries) | |||
| Textbox and multiline text | Excel Worksheet Functions | |||
| $ in front of text in a textbox | Excel Programming | |||
| check variable(text) with cell (text), textbox | Excel Programming | |||
| Help with fitting text in textbox | Excel Programming | |||
![kedarkulkarni[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
