??? Why Combobox font size shrinks with each click

[Guest]

May I have some expert advice on hy Combobox font size shrinks with each
click pls.


Many thanks in advance

 

[paul.robinson]

May I have some expert advice on hy Combobox font size shrinks with each
click pls.

Many thanks in advance

Is there any code behind the click event for the Combobox?
regards
Paul

 

[Guest]

Dear Mr Robinson

Thanks very much for your help. Yes there is. It is some code for
application.goto.

Private Sub ComboBox1_Click()
n = Cells(7, 6)
Select Case n
Case 1
Application.Goto Reference:=Worksheets("OB Input").Range("d36"), _
Scroll:=True
.....
....

 

[paul.robinson]

Dear Mr Robinson

Thanks very much for your help. Yes there is. It is some code for
application.goto.

Private Sub ComboBox1_Click()
n = Cells(7, 6)
Select Case n
Case 1
Application.Goto Reference:=Worksheets("OB Input").Range("d36"), _
Scroll:=True
....
...






- Show quoted text -

Hi
I thought some code might be changing the Font.Size property in the
combobox, but that is not in your code.
If the Excel file is not sensitive you can send it to me and I'll have
a look.
regards
Paul