ListBox highlight

[Gokz777]

Hi Everyone,

Currently working with a booking system and having difficulty with the highlight/selector function within a listbox (selecting time).

I did not code the system but am trying to work through errors.

There is a time based listbox (8:00 -17:00) which is used for bookings. A formula is linked to the listbox which indicates how many rooms are available at the selected time.


The issue is the below code. The first time selected on the list will highlight, if you click on another time the system and formula recognise it but it will not highlight. The original time stays highlighted.

If I remove the below code the new time will highlight but the formula for available rooms stops working.

'==========================================================================================================
' ## BookingTime_Click
' used to trap a click on the BookingTime Listbox control & update the available rooms
'==========================================================================================================
Private Sub BookingTime_Click()

Call UpdateAvailableRooms

End Sub



Can someone please help with this?

[natefarm]

We would need to see all the code, not just this one segment.

[Gokz777]

We would need to see all the code, not just this one segment.

Please Login or Register  to view this content.

[natefarm]

I should have said this before. Please always wrap code in code tags when posting. Please edit your posts above accordingly.

One issue I see (not that it's causing your problem) is that you are calling the UpdateAvailableRooms subroutine, but UpdateAvailableRooms is set up as a function. It may have just been a typo, or may indicate a lack of understanding of the difference between the two. Functions should return a value, like GetAvailableRooms. Which brings up the next problem. The GetAvailableRooms subroutine is missing from the code provided, so further evaluation isn't possible.

I'm taking off for the Thanksgiving weekend, so if someone else wants to jump in after Gokz777 responds, be my guest.