commandbutton

Hi all, I'm trying to use an activex button to activate a macro defined in a different cell.... Below, the macro name is defined in cells A1,A2 and A3, Command buttons are then inserted and required to run the macro defined in column A. A B 1 Macro1...

I've got a workbook which contains multiple sheets of data. A new sheet can already be created using a macro, but I want the last part of that procedure to involve placing a CommandButton or hyperlink on the Dashboard sheet which links back to the sheet. I need some code which adds a...

Hi, I'm creating a measurment document were I would like to have several combined ComboBoxes and then send that information to another workbook. I've done this with Data Validation Lists, but I got more then 8 choises and it's a pain to work with a scroll-list. I've been able to combine the...

Hello, This is my first post and I am glad to help / have some of my questions answered concerning Excel and VBA. Anyway, my problem is that I have a userform called "update_log_form" and I have a bunch of buttons where for each button I want to change the captions. GOAL: easily change button...

Hey Everyone, I am trying to create Minesweeper in excel (to increase office productivity). I am already pretty good with VBA so creating it in a worksheet would be a cakewalk for me, so I am trying to create it in a user form.I also want to learn how to get better with class modules, which...

Hi. Please bear with me on this as I am not a power user and this is my first macro. I have looked in tutorials, the Dummies book and tried to search here on the forum before posting and didn't find guidance. Someone recently wrote a macro for me that is initiated by clicking on a button and...

I've been designing a userForm where the user can input a certain string into an Inputbox which will set off a load of Macros. The problem is that the Inputbox comes up multiple times depending on which code the user inputs. For example, if the user inputs 100H2102 it does it first time. If he...

Hello guys, i have not a long time ago got Excel 2010. I have a problem with it, In school we are learning to develop. This means we do a lot of Active X objects, mostly Commandbuttons. But on my new Excel this does not work. I never had Excel before on my computer, except a Trial for a month...

I want to use a userform to build & edit an email distribution list in Sheet 1 Column G. I would like to do this with 2 TextBoxes, and 3 Command Buttons, to perform the following objectives. 1. email address entered in textbox1, pressing commandbutton1("add") would input value into sheet1.g1...

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...

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...

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...

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...

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...

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...

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>...

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...

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.

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...