HI, I have just started using excel after becominreasonable profficient in Access.
Eeeeek, there are no do it your self cut and paste macros! Ouch!
Here is what I need. I need to know how to clear a row in a table from a for in another worksheet. This worksheet contains textboxes and drop down menus which link to tables in other worksheets. I want to put a command button on the main form whcih will clear all the contents of these text boxes and the cells they link to.
It would be ideal that a refresh - clear contents fromm these rows acts on iniciation of the workbook.
Also, I would like to open different worksheets from command buttons on the main form.
Sorry. Am I asking too much? I am just starting out
Thanks
Mathew
Eeeeek, there are no do it your self cut and paste macros! Ouch!
Here is what I need. I need to know how to clear a row in a table from a for in another worksheet. This worksheet contains textboxes and drop down menus which link to tables in other worksheets. I want to put a command button on the main form whcih will clear all the contents of these text boxes and the cells they link to.
It would be ideal that a refresh - clear contents fromm these rows acts on iniciation of the workbook.
Also, I would like to open different worksheets from command buttons on the main form.
Sorry. Am I asking too much? I am just starting out
Thanks
Mathew