Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 846
Default Combo Box Problems

Thanks for taking the time to read my question.

I have 4 combo boxes. Based on data on my sheet, the combo boxes
ListFillRange changes. The ListFillRange can be either 1 row that includes 2
colums, or any number of rows that include 2 columns.

My problem is, when I choose either the first or last item in the list,
click away from the combo box and click back in the combo box, the value
dissappears. This does not happen for any other values. This is consistent
across all 4 combo boxes.

Any ideas why this may happen?

Here is the code for one of the combo boxes (all combo box code is the
same... save references)

CODE:
-------------------------------------------
Private Sub ComboBox9_Change()
If ClosingDontRun = True Then Exit Sub

If Sheets("Flock Sheet").ComboBox7.Value < BeforeUpdateComboValue Then
JustGotFocus = False
End If

If JustGotFocus = True Then Exit Sub

If Sheets("Code").Range("K5").Value < "" Then
Sheets("Flock Sheet").ComboBox14.Enabled = True
UpdateFeed = True
UpdateFeedRequirements
End If
End Sub

---------------------------------------------------------------

Private Sub ComboBox9_GotFocus()
JustGotFocus = True
BeforeUpdateComboValue = Sheets("Flock Sheet").ComboBox7.Value
If ClosingDontRun = True Then Exit Sub
If Sheets("Flock Sheet").Range("J15") = "NONE" Then
Sheets("Flock Sheet").ComboBox9.ListFillRange = "Code!$X$9:$Y$9"
Else
x = 9
Do Until Sheets("Code").Cells(x, 24).Value = ""
If Sheets("Code").Cells(x, 24).Value < "" Then
x = x + 1
End If
Loop
Sheets("Flock Sheet").ComboBox9.ListFillRange = "Code!$X$9:$Y$" & x - 1
End If
End Sub

----------------------------------------------------------

Thanks again for the help.

Brad
Reply
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
Combo problems Geoff Excel Discussion (Misc queries) 1 August 11th 08 11:50 AM
Combo Box List Problems robert inman via OfficeKB.com Excel Discussion (Misc queries) 3 May 5th 05 01:30 PM
List/Combo Box Setup Problems Phil Hageman[_3_] Excel Programming 3 April 12th 04 08:16 PM
Problems with combo boxes Jody[_4_] Excel Programming 1 December 31st 03 09:42 PM
combo box, index formula problems mark67 Excel Programming 1 October 17th 03 11:11 PM


All times are GMT +1. The time now is 03:14 PM.

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

About Us

"It's about Microsoft Excel"