将vbCrLf应用于文本框的内容 [英] Applying vbCrLf to the content of a textbox

问题描述

我在Excel vba项目中有一个用户窗体。在设计时它是空的。

在初始化事件表单中，我有以下代码：

  Private Sub UserForm_Initialize（）
 
 txtSQL.value = _ 
SELECT MyName =ColY& vbCrLf& _ 
FROM SomeTable& vbCrLf& _ 
GROUP BY顾客& vbCrLf& _ 
客户DESC订单
 
结束子
  

我希望在文本框中有4个单独的文本行，而是具有以下内容：

我使用错误的控件？或者我以错误的方式使用正确的控件？

解决方案

糟糕：也许我应该睡觉...

在设计时将多行属性设置为True！

I've got a userform within an Excel vba project. At design-time it is empty.

In the form initialize event I've got the following code:

Private Sub UserForm_Initialize()

txtSQL.value = _
    "SELECT MyName = ""ColY"" " & vbCrLf & _
    "FROM SomeTable " & vbCrLf & _
    "GROUP BY Customer " & vbCrLf & _
    "ORDER BY Customer DESC"

End Sub

I was hoping for 4 separate lines of text in the textbox but instead have the following:

Am I using the wrong control? Or am I using the right control in the wrong way?

解决方案

Whoops: maybe I should go to bed...

At design-time set multi-line property to True!

这篇关于将vbCrLf应用于文本框的内容的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！