commandbutton

  1. S

    VBA code: safe files based on command button parameters or sub

    Hello everybody, I use a PC with windows 7 64bit and office/excel 2010. I already tried to search the forum, but didn't find anything related to this matter, or didn't know the right keywords... Recently, I inherited a few macro files, that I am trying to "clean-up" or improve now. The first...
  2. A

    Not sure how to write the code for the command button when making a userform

    Could someone kindly just look at the code and tell me what to change, Thank you this is my first time doing this and I got really confused when looking at other people examples. Underneath is a screenshot of what I'm trying to create but every time I try to add the information this error pops...
  3. T

    2 Listbox selection to a worksheet

    Hi, I have two multi column Listbox on a userform, the first listbox1 finds details about a customer Order. Listbox2 displays the current stock. Now Listbox1 is a single line selection and Listbox2 is a multi line selection, So to fill a order you select the order from Listbox1 and then the...
  4. S

    Show message and command button when cell value changes

    Dear all, I looked up several posts within this and other forums but I cannot get my code to work. One of the reasons might be that I am absolutely VBA-naive ... Here is the simple problem: I have a drop-down (via Data - Data validation - list) in cell D8 of a Excel 2013 work sheet. I inserted...
  5. C

    Problem with Command Button and textbox.setfocus

    I have a simple excel spread sheet that I am using VBA to run a form. What I want to do is when the enter key is hit on the NextRecord button (which puts the entries into my spreadsheet) I want the focus to turn back to TextBox4. Instead the cursor is moving to the next command box. I know...
  6. B

    Help with a stopwatch on a userform?

    Hi - So I'm trying to get a stopwatch on a userform that has a bunch of other fields as well. This is the code that I'm using: Dim StopTimer As Boolean Dim Etime As Single Dim Etime0 As Single Dim LastEtime As Single End Sub Private Sub TimeReset_Click() StopTimer = True Etime = 0 Etime0...
  7. Z

    How to save a userfor textbox input as a global variable to use late?

    So I am using the Private Sub CommandButton1_Click() to get some values from the user and most of them go to certain cells on my worksheet. However, there is one particular value (a dollar amount) that I do not want to store, but use later on to compare against a different value. I tried...
  8. T

    Need Help with VBA code

    Hello, I am trying to set up an order sheet and I am trying to figure out how to get a command button to do all the functions I want it to. So far I only have it inserting new line relative to the position of the command button. Private Sub CommandButton2_Click()...
  9. R

    How to create a button on each row with value having the same macro?

    Hello guys. I'm new in excel vba programming, so I dunno a lot of stuffs yet. But I'm hoping someone could help me on what I plan to do. So Here it is: I want to create a button for each row with a value on a certain range. For example: if A1 has a value, it will create a button on D1...
  10. J

    Troubles saving using ActiveX Command Button

    Hello world, I am attempting to use a single command button to save two sheets using VBA, but Excel (2010) keeps crashing on me. I'm new to VBA, have learned a ton from the members on here, and I know that I must be doing something wrong. I would like to use a command button located in Sheet1...
  11. J

    Coding combobox to set autofilter parameters in worksheet

    I am pretty new at VBA and am not sure why I am getting object error 424 Here is the code so far. Private Sub Workbook_Open()With Sheet1.ComboBox1 .AddItem "" .AddItem "5% or less" .AddItem ">5 - 15%" .AddItem ">15% - 25%" .AddItem ">25% - 35%" .AddItem ">35%" End With With Sheet1.ComboBox2...
  12. J

    Using an ActiveX button to call a macro determined by a cell reference

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

    Trying to create an index sheet with CommandButtons or Hyperlinks

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

    Comboxes & Commandbutton

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

    VBA Userform Question - Naming Commandbuttons

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

    VBA Help Needed - Class Module for CommandButton

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

    Total noob - how to modify the look/type of commandbutton (excel2011, Mac)

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

    Userform input box to stop looping

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

    Error Active X: "Cannot insert object"

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

    Enter, Edit, & Display Data Userform

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

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top