Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forms - return keyed leaves square
On my forms when you use return key in field it displays a square symbol on
worksheet and also prints - how do I hide this? tia |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forms - return keyed leaves square
First, make sure Wrap Text is set for the Cell. If that doesn't correct it,
then Remove any ControlSource property setting. Then Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean) With Worksheets("Sheet1") .Range("B9").Value = Replace(TextBox1.Text, Chr(13), "") End With End Sub -- Regards, Tom Ogilvy "themillman" wrote in message ... On my forms when you use return key in field it displays a square symbol on worksheet and also prints - how do I hide this? tia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I a rotate my square radar chart (square-diamond)? | Charts and Charting in Excel | |||
how to center a square plot area in a square chart | Charts and Charting in Excel | |||
Regression Output -- R Square versus Adjusted R Square | Excel Discussion (Misc queries) | |||
Help w/ macro to zero hard keyed numbers | Excel Programming | |||
Shapes.. trying to print a square square | Excel Programming |