1. E

    Processing multiple command buttons in a userform - best practice

    I am currently attempting to enhance a VBA macro that produces multiple sheets of data from an input data file which are used for task management purposes. Because so many sheets are generated, my users wish to have the option to selectively print the contents based on a number of different...
  2. R


    I have an excelsheet with a certain range "realusedrange" that has to be pasted in a Powerpint-slide. Because I want to give the user the possibility to make complete the range I made a commandbutton on the excelsheet. When the user presses this button another macro should be started where the...
  3. C

    Reducing the width of command button

    Hi, i want o make some command buttons on a sheet with the width 50 and when you move the mouse over to any one the width of that one should increase to 300. when you move he mouse over to the other one the size of the previous one should return to 50 and the new one (now under the mouse) should...
  4. P

    Command Button Search

    Hello, I have found great information in this forums but now im stuck. Im trying to make the command button search within the workbook for the value of cell H2. This is what i have right now, but instead of the input box i want it to automatically choose the value in cell H2 and search...
  5. J

    Command Button In Front of Web Browser

    I don't know if this is possible, I have searched and searched and couldn't find an answer. Is it possible to display command buttons in front of a web browser on a userform??? I have tried clicking on bring to front option several times but it still remains behind the userform when I run...
  6. S

    Use VBA to add new button AND its code

    I have a spreadsheet which walks the user through how to add data to it in the correct manner. As such, I want to be able to write a macro that will add a new page AND on that page there to be a button with code behind it (only simple code to take the user back to the main menu). So far I...
  7. D

    Enable/disable CommandButton

    I created CommandButton1 using Control Toolbox and I set its property to Enabled = True. Is there a (simple) way to swap between Enable/Disable from macro? <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> The line <o:p> </o:p>...
  8. mike31z

    CommandButton userform vs worksheet

    I have a Userform with 15 text box that I entered participant data into and when finished I click on the Command Button to post the data to the database on a seperate worksheet. That all works fine but now is the time to evolve our spreadsheet. I want to be able to do the same thing from a...
  9. G

    using a Cmd button's location as a relative reference

    I want to use a command button that unhides the row below it. However there are going to be 50 buttons. Is there a way to use the button that was pressed as the reference to make the cell beneath it active and change the row height. I am trying to avoid using 50 different macros.
  10. J

    Illegible caption on command button

    In Excel 2003, under XP, I am placing command buttons from the controls toolbox on spreadsheets. The captions are not shown in the default or selected fonts except when the button is clicked at run-time. Then the font returns to its hard-to-read state. I seem to recall finding a solution to...

Some videos you may like

This Week's Hot Topics