I have set up a user form with a combo box of dates (Worksheet 1 A1:Z1 transposed as source) and a list box of names (Named Range). Worksheet 1 has the dates of meetings acroos the top and the list of names in column A. I am working on a code that when the command button is pressed it will search worksheet 1 and locate the cell that intersects the date selected in the combo box and the name selected in the list box. As if this weren't difficult enough, the list box is multi select! The purpose of this form is to record attendees at meetings. Is there anyone out there who can please assist me!! The code below works to select the cell that matches the combo box selection, but this is as far as I can get. This is my first time using VBA and I am getting extremely frustrated.
Bookmarks