Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
My app is not working stable I suspect the following code
I'm using for combobox. Private Sub ComboBox1_Change() On Error GoTo ComboBox1_Change_Err Me.ComboBox1.ListFillRange = "R3:R97" With Worksheets("Legend").Range("a3:a448") .Borders.LineStyle = xlLineStyleNone .Borders.ColorIndex = 2 .Borders.Weight = xlThin Set c = .Find(ComboBox1.Value, LookIn:=xlValues) c.Borders.LineStyle = xlDouble c.Borders.Weight = xlThick c.Borders.Color = RGB(255, 0, 0) c.Activate End With Application.ScreenUpdating = True ComboBox1_Change_exit: Exit Sub ComboBox1_Change_Err: MsgBox Error Resume ComboBox1_Change_exit End Sub Could anybody look at this and say whether it's Ok to be used for combobox? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combo Box Code | Excel Discussion (Misc queries) | |||
Drop down or Combo Box Help with VBA code and formula | Excel Worksheet Functions | |||
combo box on change code | Excel Discussion (Misc queries) | |||
Combo Box Code | Excel Discussion (Misc queries) | |||
Help with Combo Box code | Excel Programming |