Hi, I'm extremely new to VBA and would love some advice. I'll try to explain as best I can. (Sorry for any improper wording...)

I have a little form on an Excel worksheet. It includes a field for an Organization Name, and a combo box drop-down to select a Date. On another worksheet, I have a calendar. Each date box on the calendar (ranges of three cells) has been named "May 1", etc., exactly like the options on the Date drop-down list.

I want the user to fill out the form, click a button and have the data from Organization Name to appear in the appropriate calendar box, depending on what Date the user has entered on the form.

Essentially, I want to modify this:
    Sheets("Calendar View").Activate
    ActiveSheet.Range("name").Select
so that "name" refers to the value of "drop_date" (which is the name of the combo box that contains the date).

Hope I explained that correctly. Any help would be greatly appreciated!