If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
2 part question - macro / command button
first of all I seem to be having a little difficutly in recording a macro to
just open a form to input database information on the row under the labels of each column. I know I can just open form after highlighting the row of labels and put the information in that way. But I want a button on the spreadsheet to click onto to open the form to input the data, and a button to do a search in the same fashion. My first problem is getting the macro to record properly. Second will be to get the command button to run the macro. I think I can do the second part of this but need the macro to do it. |
#2
|
|||
|
|||
To open the built-in Data Form, you could add the Form button to your
toolbar: Choose ToolsCustomize Click on the Commands tab Select the Data category Drag the Form command to an existing toolbar Click Close To use it, select a cell in your list, and click the Form button. You could also try John Walkenbach's Enhanced Data Form. It's a free add-in that allows combo boxes, and unlimited fields. http://j-walk.com/ss/dataform/index.htm John wrote: first of all I seem to be having a little difficutly in recording a macro to just open a form to input database information on the row under the labels of each column. I know I can just open form after highlighting the row of labels and put the information in that way. But I want a button on the spreadsheet to click onto to open the form to input the data, and a button to do a search in the same fashion. My first problem is getting the macro to record properly. Second will be to get the command button to run the macro. I think I can do the second part of this but need the macro to do it. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
When I go to drag the command over to the toolbar, it shows an x which will
not allow me to add it to the toolbar. I also wanted to try to create a form question box by using a macro to open it, I also wanted to use it to do a search as well. But my first goal is to get something to open the form to enter the data in the right row and under the right column. I will keep trying, thanks for your help Debra. "Debra Dalgleish" wrote: To open the built-in Data Form, you could add the Form button to your toolbar: Choose ToolsCustomize Click on the Commands tab Select the Data category Drag the Form command to an existing toolbar Click Close To use it, select a cell in your list, and click the Form button. You could also try John Walkenbach's Enhanced Data Form. It's a free add-in that allows combo boxes, and unlimited fields. http://j-walk.com/ss/dataform/index.htm John wrote: first of all I seem to be having a little difficutly in recording a macro to just open a form to input database information on the row under the labels of each column. I know I can just open form after highlighting the row of labels and put the information in that way. But I want a button on the spreadsheet to click onto to open the form to input the data, and a button to do a search in the same fashion. My first problem is getting the macro to record properly. Second will be to get the command button to run the macro. I think I can do the second part of this but need the macro to do it. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
|
|||
|
|||
Did you try John's Data form? It opens on the active record, but starts
in the first field. I'm not sure why you can't add the button to your toolbar. Can you create a new toolbar (ToolsCustomize, Toolbars tab), and add the button to that? John wrote: When I go to drag the command over to the toolbar, it shows an x which will not allow me to add it to the toolbar. I also wanted to try to create a form question box by using a macro to open it, I also wanted to use it to do a search as well. But my first goal is to get something to open the form to enter the data in the right row and under the right column. I will keep trying, thanks for your help Debra. "Debra Dalgleish" wrote: To open the built-in Data Form, you could add the Form button to your toolbar: Choose ToolsCustomize Click on the Commands tab Select the Data category Drag the Form command to an existing toolbar Click Close To use it, select a cell in your list, and click the Form button. You could also try John Walkenbach's Enhanced Data Form. It's a free add-in that allows combo boxes, and unlimited fields. http://j-walk.com/ss/dataform/index.htm John wrote: first of all I seem to be having a little difficutly in recording a macro to just open a form to input database information on the row under the labels of each column. I know I can just open form after highlighting the row of labels and put the information in that way. But I want a button on the spreadsheet to click onto to open the form to input the data, and a button to do a search in the same fashion. My first problem is getting the macro to record properly. Second will be to get the command button to run the macro. I think I can do the second part of this but need the macro to do it. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
A Tricky Question! Macro & Chart | hce | General Discussion | 7 | August 10th, 2004 04:07 AM |
Need Entry Point 18 Help On Access Executable File | Jeff Conrad | General Discussion | 26 | July 14th, 2004 06:00 AM |