"Strange ComboBox Behavior?"

D

Don

Good Morning Folks,

Strange problem here. On Sheet 2 I have two columns of data that propagate
two ComboBox's on a Form. This Form feeds data to Sheet1. CB1 is propogated
by Column A. CB2 by Column B. Both these lists were developed by making the
first two entries and then draging down the required number of Rows. Column
A is a list of dates representing the first day of each week of the year.
I've found no error in selecting dates in CB1. CB2 is a list of times, 12AM
to 11:45PM in 15 minute increments. All times except two work correctly.
But, at 6AM and 12PM the macro fails in the Change event with the error
listed below. Only those two times give this error. By changing those
times, on Sheet2, manually to 6:01AM and 12:01PM, the Change event works
correctly. Changing these times back to 6:00AM and 12:00PM manually and the
Change event fails again........any ideas?

Private Sub ComboBox2_Change()

ComboBox2.Value = Format(ComboBox2.Value, "hh:mm AM/PM")

End Sub

Run-time error '380':
Could not set the Value property. Invalid property value.

TIA,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top