Enter User Input Data into Next Free Cell based on Column Name

Hi everyone,
I am trying to create a user friendly macro for entering new meeting information based on the contacts name.
For example i have a sheet (attached), and i want to be able to click a button and then the user inputs a name, and also inputs a meeting note.

Name: John <- user input
New Meeting Note: JD 1/1/11 <- user input

I hoped to create a macro to search for the name input in column A and then input the "New Meeting Note" in the next available cell.
I was thinking it could find the column titled "Meetings" then search for the next blank cell to the right of it as there could already be data in the Meeting column, and possible a number of columns to the right as well.

See the attached for a visual

Cheers for any help.

Hi nKife and welcome to ExcelForum,

See the attached file (based on your original file) which uses a UserForm to select an existing name, and entry and posting of a Meeting Note.

There are 3 modules that contain code:
Sheet1 module:

Please Login or Register  to view this content.

UserForm1 module:

Please Login or Register  to view this content.

Ordinary Code Module (ModUserForm1):

Please Login or Register  to view this content.

---------------------
The following may help access the code and learn what is going on:

To access a Module in VBA:
a. 'Left Click' on any cell in the Excel Spreadsheet.
b. ALT-F11 to get to VBA.
c. CTRL-R to get project explorer (if it isn't already showing).
d. 'Double Click' on the module you want to access in the 'Project Explorer'.
e. Insert code into the module if needed. 'Option Explicit' should only appear ONCE at the top of the module.

NOTE: To access UserForm code, 'Right Click' on the UserForm module, then select 'View Code'. To access the UserForm itself, 'Double Click' on the UserForm module.

Debugger Secrets:
a. Press 'F8' to single step (goes into subroutines and functions).
b. Press SHIFT 'F8' to single step OVER subroutines and functions.
c. Press CTRL 'F8' to stop at the line where the cursor is.
d. 'Left Click' the margin to the left of a line to set (or clear) a BREAKPOINT.
e. Press CTRL 'G' to open the IMMEDIATE WINDOW. 'debug.print' statements send their
output to the IMMEDIATE WINDOW.
f. Select View > Locals to see all variables while debugging.
g. To automatically set a BREAKPOINT at a certain location put in the line:
'Debug.Assert False'
h. To conditionally set a BREAKPOINT at a certain location put in lines similar to:
if i >= 20 and xTV20 > 99.56 then
Debug.Assert False
endif
i. A variable value will be displayed by putting the cursor over the variable name.
---------------------

Please let me know if you have any problems or questions.

Lewis