Home |
Search |
Today's Posts |
#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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looping Macro That adds a blank row between different part #'s | Excel Discussion (Misc queries) | |||
Macro Question? | Excel Discussion (Misc queries) | |||
Macro Question? | Excel Worksheet Functions | |||
How do I edit a formula as part of a macro? | Excel Discussion (Misc queries) | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions |