Get instant live expert help on I need help with excel assign macro to button
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Hello, I need to know how to assign data to a macro buttons so that when clicked, data from another sheet automatically populates on the sheet the macro button is on.
Solved by B. W. in 17 mins
I have a save button on my excel sheet and would like to assign a macro to it that allows me to open up the "Save As" dialog box with the location being specific and the working being saved as a "Excel Macro-Enabled Workbook" file
Solved by F. F. in 16 mins
Create a form control button beginning in the top-left corner of cell F4 and ending in the top-left corner of cell G7. Assign the Sort macro. Edit the button text to display the word Sort.
Solved by A. L. in 15 mins
3. Create a macro (in this worksheet and assign to the shortcut key Ctrl+h) name it Headings. The macro formats cell A1 to Bold, 18 pt, pink font colour then inserts the heading PRICE LIST, then formats cell A2 to Bold, 14 pt then inserts the subheading Cross Stitch Kits. 4. Create a macro (in this worksheet and assign to a button on the toolbar) named Format. The macro formats the Cost figures to currency. Test the macro works by selecting the Retail figures and running the macro.
Solved by G. H. in 11 mins
Help testing a macro button on ex 448. Creating macro button
Solved by F. H. in 25 mins