combo

  1. B

    Help Making a Calculator

    Hey everyone, Here's a spreadsheet I am working on: https://www.dropbox.com/s/xavhulqwi91xamh/Profitability%20Calculator.xlsx?dl=0. My goal is to make a calculator that is streamlined and aesthetically pleasing as I can. Right now, I have set it up to do the calculations for me, but I have hit...
  2. S

    Combo Box Autocomplete Sorting / Returning Values On Top

    Hi guys, The sheet I'm working on has a set of data where a user would select from a combo box with an autocomplete feature (taken from other resources). When I click on the combo box, the list comes up like below (as it should, and this is fine): But when you type in a letter for example...
  3. C

    Dependent Combobox

    Hello every one. I try to make a dependent combo box but are not be able to solve my difficulties. That its not dependent.
  4. B

    Importing from from one DB to another

    I imported a form from one db to another and I seemed to have lost some of the form functionality. Before the form was imported (in the original DB) all the fields would update when I selected a member from a combo box. However, the imported form doesn't do this. None of the fields respond to...
  5. E

    Pivot table formatting persists

    I have two pivot tables in two worksheets. The first one is controlled by a combo box in which the user selects a business ID. The information for that ID then appears in that worksheet's pivot table. The second pivot table has two combo boxes that are filled based on the user's selection in...
  6. E

    Filter Pivot Table with VBA

    I'm trying to filter a pivot table when the user selects an item from an ActiveX combo box. (I need to use the ActiveX combo box because after the user selects an item I want a combo box in another worksheet to populate based on the user's selection. I haven't found a way to do that using...
  7. P

    Combo Box on Protected sheet problems

    In Excel 2013 from Office 365: Problem: I lose combo box functionality when I protect my worksheet. Current solutions I've attempted: I am using an active X combo box for a drop down list using data validation with a named range (CName). The named ranged of the data validation list (CName)...
  8. L

    Reset Combo Box with Active X Control to first value

    I have an Excel sheet with a number of combo boxes. The one I need to rest the value for is called "Store". How do I reset this Combox to the first value in the Named Range?
  9. B

    Changing Combo box Control in a table to a text box - getting read only option

    I have a field in my table that was initially set up as a combo box. It is currently populated and updated by using a form that was created for this purpose. There are presently over 3000 cells of data that have been selected in this field by using the combo box method via a form. However, I...
  10. C

    Userform_initialise Vs Userform_Activate

    Hi I have a code for a userform with a series of combo boxes that are populated from cell ranges. I get an error when i try and put the code to populate the combo boxes in the initialize sub. So i had to add them under a new sub acitivate Is there a way to combine these two subs together? Is it...
  11. A

    combo box value from another workbook

    Hi, I am creating excel macro for combo box in user form. I have succeed to create in single workbook. Here is my code in current workbook. ComboBox1.RowSource = "Sheet1!G1:G" & Range("G" & Rows.Count).End(xlUp).Row What I want to do now is, I want to get the value for my combo box from...
  12. C

    Combo Box form control

    2 questions about combo boxes. I have one that references a column with 9 entries. Depending on the value in a cell some of those entries may be blanked out because they are invalid. A blank cell could of course be erroneously selected and need correction. Is there a better way to handle...
  13. RasGhul

    vba Delete Row and Member

    Hi Team, I have a 200 member data set columns A:I and a combo box with the members names DV. When I select someones name from the combo box I would like to delete that row from A:I. I was tinkering with the selection.delete shift:= xlUp function but couldn't define the needed objects etc. it...
  14. M

    Multiple Criteria on Form to open Report

    I have a form with 1 combo box and 2 text boxes all are unbound. My combo box is named combo6 and and the text boxes are text2 and text4. The combo box houses the EmployeeName; and the 2 text boxes gives a choice for a start date and an end date. My report to be opened: EmpBalSheet. The...
  15. J

    Search combo box

    Hello, I have a combo box in a form so street names are the same format (Avenue, but not Ave or Road but not Rd). A user will type a home address, then choose the street from the combo box. I'm wondering now if I can put my cursor in the combo box field and search for a specific street. For...
  16. O

    Filter choice selection based on combobox values

    Hi, im trying to get the value from the combo box to filter the data in sheets as i dont use userform. but the combobox value cant be detected. i didnt know if i dont declared it as string or because of the value inside the combo box is too long. i used 2 code to add value in combo box (array &...
  17. R

    User Form Combo Box

    Is there a way for the combo box to show the last item that was selected? if they choose Apples then submitted their data can Apples then show up in that combo box next?
  18. D

    Excel VB Coding

    Hello I have been using this form in the past and with it I have been able to produce combo boxes that are dynamic. I’d like to take the combo box to another level and allow users to scroll through the results with the arrow keys. The only problem is that the field updates to the first item...
  19. D

    Hide formulas in formula bar and cell

    Is there a way I can hide formulas from showing in a cell & formula bar? I have a ActiveX Combo Box control button on the worksheet that depending on what text is entered into the box, the resulting data below the box in the worksheet automatically changes. I have tried to lock/protect the...
  20. Calvary

    Combo box issue

    Hi All, I'm having a bit of a problem getting a combo box to do what I'd like. Esscentially what I want is the combo box to read the text box above called "accnumber" and check the first 2 characters. If they show "CA" then the box should only show "Mobile" else 2 other options. With system...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top