inserting data from visual basic form

Can anyone tell me how to get the information from a combo box on a visual basic form and then insert the information into a specified place. Currently in my calander excel software i have been able to select the correct sheet and the correct cell to have the data inserted into but i dont know how to insert the text in the combo box in the form.

Can anyone help me please

Hello Jexy,

Here's how...

Please Login or Register  to view this content.

This example puts the user selection from ComboBox1 into thet worksheet cell A1 on Sheet1. Change these names to match what you are using. The "If" statement tests if the user has selected anything. This avoids a program error.

Sincerely,
Leith Ross