Hello,
I am somewhat new to excel & all that it can do. I am creating a form on a worksheet various form controls & when I click a command button I want it to be added to the database & the cells cleared & form controls reset. I have tried this with only for cells transferring over to the database, but the code isn't very clean & there are no defined names for the cells or form controls. I have borrowed a copy of Excel 2003 Power Programming with VBA & am lost. Will someone help me
Andy in Salem
I am somewhat new to excel & all that it can do. I am creating a form on a worksheet various form controls & when I click a command button I want it to be added to the database & the cells cleared & form controls reset. I have tried this with only for cells transferring over to the database, but the code isn't very clean & there are no defined names for the cells or form controls. I have borrowed a copy of Excel 2003 Power Programming with VBA & am lost. Will someone help me
Andy in Salem