|
Command Button for Macro on a Toolbar
Hi fellow Excel Users
I have a couple of questions I know how to create a command button using The Control Toolbox 1. How do I record a macro and assign it to this command button 2. How do I get the command button to sit on my toolbar. Many thanks in advance |
Command Button for Macro on a Toolbar
Hello
1- Record your macro, when finished, right-click on your command button, select view code and just enter your macro name under Private Sub CommandButton1_Click(). eg: Private Sub CommandButton1_Click() MacroNameHere End Sub 2- Command buttons are objects related to sheets and therefore cannot be placed into the Excel toolbar. If your wish is to execute some code when clicking on a button from the toolbar, you may consider building a custom commandbar button and assign a macro to it. HTH Cordially Pascal "Office Junior" a écrit dans le message de news: ... Hi fellow Excel Users I have a couple of questions I know how to create a command button using The Control Toolbox 1. How do I record a macro and assign it to this command button 2. How do I get the command button to sit on my toolbar. Many thanks in advance |
Command Button for Macro on a Toolbar
Thanks Papou. I am now getting this Error Message:
Compile error: Expected:= What do I do here "papou" wrote: Hello 1- Record your macro, when finished, right-click on your command button, select view code and just enter your macro name under Private Sub CommandButton1_Click(). eg: Private Sub CommandButton1_Click() MacroNameHere End Sub 2- Command buttons are objects related to sheets and therefore cannot be placed into the Excel toolbar. If your wish is to execute some code when clicking on a button from the toolbar, you may consider building a custom commandbar button and assign a macro to it. HTH Cordially Pascal "Office Junior" a écrit dans le message de news: ... Hi fellow Excel Users I have a couple of questions I know how to create a command button using The Control Toolbox 1. How do I record a macro and assign it to this command button 2. How do I get the command button to sit on my toolbar. Many thanks in advance |
Command Button for Macro on a Toolbar
For the macro?
I just recorded the macr. don't understand coding much but here it is: Columns("A:A").Select Selection.Delete Shift:=xlToLeft Range("A1").Select ActiveCell.FormulaR1C1 = "WBS" Range("B1").Select ActiveCell.FormulaR1C1 = "Name" Range("C1").Select ActiveCell.FormulaR1C1 = "Pers. No" Columns("F:G").Select Selection.Delete Shift:=xlToLeft Columns("D:D").Select Selection.Insert Shift:=xlToRight Range("F9").Select ActiveWindow.SmallScroll ToRight:=4 ActiveWindow.ScrollColumn = 1 ActiveWindow.SmallScroll ToRight:=3 ActiveWindow.ScrollColumn = 3 ActiveWindow.ScrollColumn = 2 ActiveWindow.ScrollColumn = 1 "papou" wrote: Can you post a portion of your code? Cordially Pascal "Office Junior" a écrit dans le message de news: ... Thanks Papou. I am now getting this Error Message: Compile error: Expected:= What do I do here "papou" wrote: Hello 1- Record your macro, when finished, right-click on your command button, select view code and just enter your macro name under Private Sub CommandButton1_Click(). eg: Private Sub CommandButton1_Click() MacroNameHere End Sub 2- Command buttons are objects related to sheets and therefore cannot be placed into the Excel toolbar. If your wish is to execute some code when clicking on a button from the toolbar, you may consider building a custom commandbar button and assign a macro to it. HTH Cordially Pascal "Office Junior" a écrit dans le message de news: ... Hi fellow Excel Users I have a couple of questions I know how to create a command button using The Control Toolbox 1. How do I record a macro and assign it to this command button 2. How do I get the command button to sit on my toolbar. Many thanks in advance |
Command Button for Macro on a Toolbar
Which line is highlighted when the error occurs?
Cordially Pascal "Office Junior" a écrit dans le message de news: ... For the macro? I just recorded the macr. don't understand coding much but here it is: Columns("A:A").Select Selection.Delete Shift:=xlToLeft Range("A1").Select ActiveCell.FormulaR1C1 = "WBS" Range("B1").Select ActiveCell.FormulaR1C1 = "Name" Range("C1").Select ActiveCell.FormulaR1C1 = "Pers. No" Columns("F:G").Select Selection.Delete Shift:=xlToLeft Columns("D:D").Select Selection.Insert Shift:=xlToRight Range("F9").Select ActiveWindow.SmallScroll ToRight:=4 ActiveWindow.ScrollColumn = 1 ActiveWindow.SmallScroll ToRight:=3 ActiveWindow.ScrollColumn = 3 ActiveWindow.ScrollColumn = 2 ActiveWindow.ScrollColumn = 1 "papou" wrote: Can you post a portion of your code? Cordially Pascal "Office Junior" a écrit dans le message de news: ... Thanks Papou. I am now getting this Error Message: Compile error: Expected:= What do I do here "papou" wrote: Hello 1- Record your macro, when finished, right-click on your command button, select view code and just enter your macro name under Private Sub CommandButton1_Click(). eg: Private Sub CommandButton1_Click() MacroNameHere End Sub 2- Command buttons are objects related to sheets and therefore cannot be placed into the Excel toolbar. If your wish is to execute some code when clicking on a button from the toolbar, you may consider building a custom commandbar button and assign a macro to it. HTH Cordially Pascal "Office Junior" a écrit dans le message de news: ... Hi fellow Excel Users I have a couple of questions I know how to create a command button using The Control Toolbox 1. How do I record a macro and assign it to this command button 2. How do I get the command button to sit on my toolbar. Many thanks in advance |
Command Button for Macro on a Toolbar
Hi Papou
What I have done is I hve taken the whole code and pasted it in the Command Box Code and deleted one "end Sub". Now I need to figure out How I can now put this Command button in a Tool Menu and get that Tool menu to sit in the Toolbar Menus. Am I making anymore sense, I don't feel like I am after the a.m I have had. Thanks "Office Junior" wrote: For the macro? I just recorded the macr. don't understand coding much but here it is: Columns("A:A").Select Selection.Delete Shift:=xlToLeft Range("A1").Select ActiveCell.FormulaR1C1 = "WBS" Range("B1").Select ActiveCell.FormulaR1C1 = "Name" Range("C1").Select ActiveCell.FormulaR1C1 = "Pers. No" Columns("F:G").Select Selection.Delete Shift:=xlToLeft Columns("D:D").Select Selection.Insert Shift:=xlToRight Range("F9").Select ActiveWindow.SmallScroll ToRight:=4 ActiveWindow.ScrollColumn = 1 ActiveWindow.SmallScroll ToRight:=3 ActiveWindow.ScrollColumn = 3 ActiveWindow.ScrollColumn = 2 ActiveWindow.ScrollColumn = 1 "papou" wrote: Can you post a portion of your code? Cordially Pascal "Office Junior" a écrit dans le message de news: ... Thanks Papou. I am now getting this Error Message: Compile error: Expected:= What do I do here "papou" wrote: Hello 1- Record your macro, when finished, right-click on your command button, select view code and just enter your macro name under Private Sub CommandButton1_Click(). eg: Private Sub CommandButton1_Click() MacroNameHere End Sub 2- Command buttons are objects related to sheets and therefore cannot be placed into the Excel toolbar. If your wish is to execute some code when clicking on a button from the toolbar, you may consider building a custom commandbar button and assign a macro to it. HTH Cordially Pascal "Office Junior" a écrit dans le message de news: ... Hi fellow Excel Users I have a couple of questions I know how to create a command button using The Control Toolbox 1. How do I record a macro and assign it to this command button 2. How do I get the command button to sit on my toolbar. Many thanks in advance |
Command Button for Macro on a Toolbar
ToolsCustomizeCommands.
Scroll down to "Macros" and select. Drag the smiley face up to your existing toolbar and right-click on the smiley and "assign macro". Choose your macro from the dialog and OK. Note: the options to name the button, change the smiley to another icon. Gord Dibben MS Excel MVP On Fri, 11 May 2007 05:20:00 -0700, Office Junior wrote: Hi Papou What I have done is I hve taken the whole code and pasted it in the Command Box Code and deleted one "end Sub". Now I need to figure out How I can now put this Command button in a Tool Menu and get that Tool menu to sit in the Toolbar Menus. Am I making anymore sense, I don't feel like I am after the a.m I have had. Thanks "Office Junior" wrote: For the macro? I just recorded the macr. don't understand coding much but here it is: Columns("A:A").Select Selection.Delete Shift:=xlToLeft Range("A1").Select ActiveCell.FormulaR1C1 = "WBS" Range("B1").Select ActiveCell.FormulaR1C1 = "Name" Range("C1").Select ActiveCell.FormulaR1C1 = "Pers. No" Columns("F:G").Select Selection.Delete Shift:=xlToLeft Columns("D:D").Select Selection.Insert Shift:=xlToRight Range("F9").Select ActiveWindow.SmallScroll ToRight:=4 ActiveWindow.ScrollColumn = 1 ActiveWindow.SmallScroll ToRight:=3 ActiveWindow.ScrollColumn = 3 ActiveWindow.ScrollColumn = 2 ActiveWindow.ScrollColumn = 1 "papou" wrote: Can you post a portion of your code? Cordially Pascal "Office Junior" a écrit dans le message de news: ... Thanks Papou. I am now getting this Error Message: Compile error: Expected:= What do I do here "papou" wrote: Hello 1- Record your macro, when finished, right-click on your command button, select view code and just enter your macro name under Private Sub CommandButton1_Click(). eg: Private Sub CommandButton1_Click() MacroNameHere End Sub 2- Command buttons are objects related to sheets and therefore cannot be placed into the Excel toolbar. If your wish is to execute some code when clicking on a button from the toolbar, you may consider building a custom commandbar button and assign a macro to it. HTH Cordially Pascal "Office Junior" a écrit dans le message de news: ... Hi fellow Excel Users I have a couple of questions I know how to create a command button using The Control Toolbox 1. How do I record a macro and assign it to this command button 2. How do I get the command button to sit on my toolbar. Many thanks in advance |
| All times are GMT +1. The time now is 10:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com