You are here:

Excel/Adding lots of Add one buttons

Advertisement


Question
QUESTION: I need to make a list of my products and as orders come in quickly "add one" to according product. How do I add lots of these buttons (400) that won't take all day?
Thank you for your time!

ANSWER: There isn't enough information here to formulate a suggestion, sorry.

---------- FOLLOW-UP ----------

QUESTION: I need an add one button. I can make them one at a time making a command button in excel. It will take all day long to go through individually making these command button 400 times. Is there a quicker, or efficient way to make lots if them for different cells?

Answer
Turn on the macro recorder and record yourself creating two buttons from start to finish, make sure they're completely setup before turning off the macro recorder.  If you made a lot of mistakes along the way, turn off the recorder, delete them and start again.  Get a good clean straigh through recording of you setting up 2 buttons with no mistakes.

Turn off the recorder and paste the resulting recorded code here and we'll take a look at how we can expand that recorded activity to repeat 400 times.  Be sure to indicate here what 400 cells you're wanting to connect those buttons to, as well.
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

Excel

All Answers


Answers by Expert:


Ask Experts

Volunteer


Jerry Beaucaire

Expertise

Excel Formulas, macros, automation. Microsoft Excel MVP - 2010. Code site with free code snippets and techniques: http://sites.madrocketscientist.com/jerrybeaucaires-excelassistant/files

Experience

Microsoft Excel MVP - 2010. I have my own extensive Excel help/code site: http://sites.madrocketscientist.com/jerrybeaucaires-excelassistant/files ===================== I have been offering free assistance as an Excel aid on many web sites for many years: (http://www.excelforum.com - JBeaucaire) ======== (http://www.askmehelpdesk.com/spreadsheets - JBeaucaire) ======= (http://www.mrexcel.com/forum - jbeaucaire)

Education/Credentials
Bachelor's Degree from Azusa Pacific University in Mathematics and Music Composition

Awards and Honors
Microsoft Excel MVP 2010

©2016 About.com. All rights reserved.