Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
damorrison
 
Posts: n/a
Default wrong font

When a userform shows, the first textbox acts strange, it does this

if I want to enter a 15 it shows like this

殎5

or this, the first diget always shows up as the square thing
ŽŽ2
掎4
Here's the codes


Option Explicit

Dim i As Integer


Private Sub CommandButton1_Click()
Dim varNbRows As Double
Range("C1").Select
varNbRows = Selection.CurrentRegion.Rows.Count
If Selection.Value = "" Then
Exit Sub
ElseIf Selection.Offset(1, 0).Value = "" Then
Selection.Offset(1, 0).Select
Else
Selection.Offset(varNbRows, 0).Select
End If
Range("C1")(ActiveCell.Row).Value = TextBox1.Text
Range("D1")(ActiveCell.Row).Value = TextBox2.Text
Range("E1")(ActiveCell.Row).Value = TextBox2.Text
Range("F1")(ActiveCell.Row).Value = TextBox2.Text
Range("G1")(ActiveCell.Row).Value = ComboBox1.Text


Unload Me
End Sub

Private Sub CommandButton2_Click()
Unload Me

End Sub


Private Sub UserForm_Initialize()
CommandButton1.Caption = "Add Stair to stock "
CommandButton1.AutoSize = True
CommandButton1.TakeFocusOnClick = False
CommandButton1.TabStop = False

CommandButton2.Caption = "Cancel"
CommandButton2.AutoSize = True
CommandButton2.TakeFocusOnClick = False
CommandButton2.TabStop = False


ComboBox1.List = Array("ROUTES", "CUTS")

TextBox1.TabIndex = 1
TextBox2.TabIndex = 2
TextBox3.TabIndex = 3
TextBox4.TabIndex = 4
ComboBox1.TabIndex = 5
With ComboBox1
Application.SendKeys "%{down}"
End With
End Sub

I checked textbox1 properties and cannot find any difference to the
other boxes, so I don't understand why this is happening

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy and paste Excel chart in Word -- font compresses ScooterGirl Charts and Charting in Excel 3 February 10th 06 03:25 AM
Font used in Word won't come up in Excel - usg as data base-envel SLJackson Excel Discussion (Misc queries) 1 September 10th 05 12:31 AM
Default font for Comments Debra Dalgleish Excel Worksheet Functions 0 August 25th 05 11:55 PM
Why is first font action v-e-r-y slow? [email protected] Excel Discussion (Misc queries) 2 March 11th 05 08:01 AM
How to change the default font and size of "comments"? ClayMcQ Excel Discussion (Misc queries) 1 January 7th 05 11:43 PM


All times are GMT +1. The time now is 12:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"