User Form with Combox and ListBox

Hello, I am farily new to VBA. Was wondering if there was a code in which if I selected a value from a combobox, then a value from a listbox, it would produce an output of "1" into a certain cell? My code explains a little into what I'm trying to achieve. Thank you



Private Sub btnEnterAvailability_Click()

Dim ws As Worksheet

Set ws = ThisWorkbook.Worksheets("Availability")



If (cboMembers.Value = "Member 1") And listTimes.Value = "5:00am" Then

ws.Range("B3").Value = "Yes"

End If

End Sub

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: link to be added hereAdministrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)