command button

Hello, I'm new here and I think this is a fantastic community. I need some help here since I'm very new to excel's developer option. I would like to know how I could use a command button to address a cell value into a Text box. I want the user to click on a button and update values in...

Hello all. I am an architect and I am trying to develop a code in excel for organizing our projects. So far I have a workbook with two tabs. Sheet1 is called "Entry", Sheet2 is called "NumericalOrder", Sheet3 is called "Alphabetical Order", and Sheet 4 is called "Civil". The headers on the...

Hello all. I am an architect and I am trying to develop a code in excel for organizing our projects. So far I have a workbook with two tabs. Sheet1 is called "Entry" and Sheet2 is called "NumericalOrder". The headers on the Entry and Numerical Order sheets is Project #, Project Name...

Hello, Can someone please help me and tell me what I am doing wrong? Private Sub CommandButton1_Click() Sub test() Dim rng As Range Dim wks As Worksheet For Each rng In Sheets("ToC").Range("B3:B15") If Trim(rng.Value) <> "" Then On Error Resume Next Set wks = Nothing...

Hi, I'm just starting to get into VBA because I spent most of my time working through everything in just recording macros. With the help of a co-worker I was able to create a way to enter data into a cell and then have it come back with a message box based on different criteria. What I can't...

Hi Everyone I am very new to VBA to please go easy... I am at the tail end of a project where I need a command button to copy data from another workbook into my workbook based on a filepath that can be entered in cell D4. The reason I cannot put the filepath name in the VBA code is due to...

Howdy folks! I'm running Excel 2010 I have a worksheet ("Interface") on which are several controls. One unlocks the workbook and reveals several hidden sheets ("wbUnlock"). One locks the workbook and hides the sheets ("wbLock"). The other buttons allow users to view and retrieve data without...

Hi I'm trying to achieve the above on a user form with the below code and keep getting a key type error! can any one please help!?! Sub remove_key_click() Dim kName As String kName = cbo_KN.Value If Worksheets("Keys").Range("KeyName").Value = kName Then ans = MsgBox("Delete "...

Hi, I am trying to create a tracking spreadsheet and i need help coding my submit command button. I know how to submit data into a generic spreadsheet but my problem is i want it to submit into a table i have created. What i am looking for is: When selecting the address in the user form, the...

Ok, so I have 12 ActiveX buttons on my spreadsheet. I want to run a single Sub if any of them are clicked, but I need to know what button was clicked so that I can change the color of the button that was just clicked. I've searched around and have found some almost there answers but nothing that...

Hi all, I'm trying to change the backcolor of a command button with the on click event of the button. Seeing that I will have several buttons to change the color or, I made a separate sub to change the button backcolor with that I can just call from the on click event of the button in question...

Hi all, I have a simple macro that is attached to an active x control command button. The macro simply deletes pre-arranged unecessary cells so that a sheet can be printed efficiently: Sub delete_specified_columns() Sheets("Sheet1").Range("B:C,E:F").EntireColumn.Delete End Sub Here is an...

I have a Mastermind game sheet that uses many command buttons. After several YEARS(!), it suddenly stopped working. I'm using Excel 2010 at the office but the workbook is saved as Excel 97-2003 for compatibility with my home PC (this has worked fine for years). The buttons are all enabled and...

Thanks for taking the time to try and figure this one out! At my work we keep a log of companies that do work for us (particularly create drawings/schematics). We take their name and assign them a number. We call this an F#, which stands for Foreign Number (eg. F-125100-001 thru -999). What...

Hi All: Here are the requirements: 1) Target workbook is "lsat_v26.xlsm". 2) Source workbook is "fake_master_db5.xls". 3) Target worksheet is "LookupLists". 4) Source worksheet is "PROJECT LIST". 5) A Userform has a command button which invokes a browse-for-file window for the user to...

My level of expertise is copying code and modyifying it to my own purposes. That being said, the code that comes with the userform generated from the Excel "Form" command seems like it would be a desirable thing to have. I'm specifically looking for the code in relation to the command buttons...

I have a 52x52 matrix of cells that I use as a visual aid. Part 1: I want each of 52 Command Buttons to "Fill" a disjointed series of cells with a specific color. For example, when I "Click" "Command Button 1", I wanted cells: =A1, B2, D3:D8, J8 to change from RGB(242,242,242) to RGB(237...

Hello, I am trying to create a user friendly Form that preforms three functions: Allows the user to enter their User ID "txtParentId". ******* procedure to use the User ID entered to pull the related field data from the table "cmdSearch" Fill the first column into the first textBox...

I duplicated a work sheet with the intention of using the same macros but on the copied sheet only. However, the text has disappeared on all of the buttons of the new sheet and I don't know why. All the buttons seem to still work. NB: The button names are the same as the original sheet they...

I've spent ages searching online for something that might help my application but I can't find anything. I'm trying to create a command button that acts as a warning indicator for its respective worksheet. Pressing the button will display a list of warnings present in the spreadsheet...