james123
12-19-2006, 04:44 PM
Hi guys,
Quick few questions I need some help with:
1) Is there a way to make a macro go to the first blank row? For example, I have a few sheets all with different amounts of information in them, when I click a button "New" the macro enters a few bits of standard information, copyed from another sheet, into the cells, but I have to manually click on a new blank row and selected the first cell before clicking the button. I would like the macro to automatically go to the first blank cell, is it possible?
2) I have another macro that is started by pressing another button "Go", this searches the workbook for the information entered in cell “I7” is there a way to make the macro run when the “enter or return” key is press on the keyboard so the button does not have to pressed?
3) is it possible to make a macro (again linked to a button named "done") save the workbook?
4)lastly I have a form that searches as said in question 2, is there a way to add a “next button” that would move down the sheet a row at a time, for example row 16 is displayed in the form pressing the Next button would display row 17
Thanks for your help guys,
James :bow:
ps. the workbook is attached in the post below
Quick few questions I need some help with:
1) Is there a way to make a macro go to the first blank row? For example, I have a few sheets all with different amounts of information in them, when I click a button "New" the macro enters a few bits of standard information, copyed from another sheet, into the cells, but I have to manually click on a new blank row and selected the first cell before clicking the button. I would like the macro to automatically go to the first blank cell, is it possible?
2) I have another macro that is started by pressing another button "Go", this searches the workbook for the information entered in cell “I7” is there a way to make the macro run when the “enter or return” key is press on the keyboard so the button does not have to pressed?
3) is it possible to make a macro (again linked to a button named "done") save the workbook?
4)lastly I have a form that searches as said in question 2, is there a way to add a “next button” that would move down the sheet a row at a time, for example row 16 is displayed in the form pressing the Next button would display row 17
Thanks for your help guys,
James :bow:
ps. the workbook is attached in the post below