[求助]文本框的TEXT与VALUE这两个属性到底有什么区别

wzsy2_mrf

没有看清你的问题，我以为是在说单元格。

qee用

QUOTE:

以下是引用excelHelper在2006-9-8 16:41:35的发言：
QEE大哥，你的意思是在VB中有区别吗？能否提供一个这样的例子

在VB中标准的TEXTBOX是没有VALUE属性的.
因为TEXTBOX的值(VALUE)从名称上看也是文本型的(不然就不叫TEXTBOX了),所以就返回的数据类型和TEXT返回值不会有差异.同时,VBA(指EXCEL)的TEXTBOX又没有提供DATAFORMAT或FORMAT,NUMBERFORMAT之类的属性,其显示和实际值也是一样的.这是我下前面的结论的基本考虑.如果一定有些差别,可能在取值的速度上会有,但TEXTBOX我们不可能对其大量频繁使用,忽略之.
在有些语言中TEXTBOX有这两个属性的差别如WZSY2_MRF兄上面所说及其它的情况.
类似问题就不要深究了吧,VBA提供两个几乎一样的属性,只是微软的一种"贴心"而已,未必有什么玄机.个人观点.

northwolves

MSDN：

MSDN Home

Value Property Note: To ensure compliance with upcoming versions of Internet Explorer, we are deprecating the use of some ActiveX controls on the site. Our apologies for the inconvenience. For alternatives, try viewing the Office 2003 VBA References or Office XP VBA Language References.                            Specifies the state or content of a given control. Syntax object.Value [= Variant] The Value property syntax has these parts: Part Description object Required. A valid object. Variant Optional. The state or content of the control. Settings Control Description CheckBox An integer value indicating whether the item is selected:   Null   Indicates the item is in a null state, neither selected nor cleared.   1   True. Indicates the item is selected.   0   False. Indicates the item is cleared. OptionButton Same as CheckBox. ToggleButton Same as CheckBox. ScrollBar An integer between the values specified for the Max and Min properties. SpinButton Same as ScrollBar. ComboBox, ListBox The value in the BoundColumn of the currently selected rows. CommandButton Always False. MultiPage An integer indicating the currently active page.   Zero (0) indicates the first page. The maximum value is one less than the number of pages. TextBox The text in the edit region. Remarks For a CommandButton, setting the Value property to True in a macro or procedure initiates the button's Click event. For a ComboBox, changing the contents of Value does not change the value of BoundColumn. To add or delete entries in a ComboBox, you can use the AddItem or RemoveItem method. For a TextBox, any value you assign to the Text property is also assigned to the Value property. Value cannot be used with a multi-select ListBox.

northwolves

 MSDN Home

Text Property Note: To ensure compliance with upcoming versions of Internet Explorer, we are deprecating the use of some ActiveX controls on the site. Our apologies for the inconvenience. For alternatives, try viewing the Office 2003 VBA References or Office XP VBA Language References.                            Returns or sets the text in a TextBox. Changes the selected row in a ComboBox or ListBox. Syntax object.Text [= String] The Text property syntax has these parts: Part Description object Required. A valid object. String Optional. A string expression specifying text. The default value is a zero-length string (""). Remarks For a TextBox, any value you assign to the Text property is also assigned to the Value property. For a ComboBox, you can use Text to update the value of the control. If the value of Text matches an existing list entry, the value of the ListIndex property (the index of the current row) is set to the row that matches Text. If the value of Text does not match a row, ListIndex is set to 1. For a ListBox, the value of Text must match an existing list entry. Specifying a value that does not match an existing list entry causes an error. When the Text property of a ComboBox changes (such as when a user types an entry into the control), the new text is compared to the column of data specified by TextColumn. You cannot use Text to change the value of an entry in a ComboBox or ListBox; use the Column or List property for this purpose. The ForeColor property determines the color of the text.

excelHelper

非常感谢wzsy2_mrf朋友、QEE用大哥与NORTHWOLVES版主热情支持

yuyangqh

在VBA中搞清楚text和value是很有必要的，我就遇到过这种情况，if cells(1,1).value="00:00:00" then ......它空格也会计算成0，结果是条件为真
和if cells(1,1).text="00:00:00" then........不同它是文件，有就有，没有就没有。我发现错误又不知道错在那儿，我搞了办法天解决了

OKJSJSF

还没弄懂它

lsdongjh

你看到的是text,实际上是value！text是value根据单元格式设定显示的内容

Asv654132

If Fix(textbox1.Text) <> textbox1.Text Then MsgBox “文本框的内容不是整数”    '正常运行
If Fix(textbox1.value) <> textbox1.value Then MsgBox “文本框的内容不是整数”    '逻辑有误，两者必定不相等，原因未知