.additem

  1. TAPS_MikeDion

    How to know which button in group was selected?

    Hi all, I have three (3) button in a Group: Group Name: Sorting Button Names: FirstNameSortButton LastNameSortButton LocationSortButton Since a ComboBox cannot show more than 1 column when the "ComboBox1_Change()" event fires, I had to overlay a 2 column ListBox on top of my ComboBox so all...
  2. TAPS_MikeDion

    Listbox w/Day of the Week & Start/Finish Times Column Headers, and HH:MM format

    Hey guys, My assumption is that there has to be a better way. In my ListBox, I'm trying to get 3 column headers (DAY | START | FINISH) and also have the time displayed in the list as 10:00AM, as opposed to being a decimal (0.41666666), which is why I was trying "* 24" in the code. If anybody...
  3. L

    ComboBox drop down list from Table not manually typed

    One of my user forms has a list of networks that currently I have hard coded for the drop down list using .AddItem, is there a way to point to a table containing the list to populate the combobox? current code: Private Sub UserForm_Initialize() ' Create dropdown list for Network With...
  4. M

    Excel Listbox displays default value but does not retain in within Sub (unless you click on selection)

    0 <button class="js-vote-down-btn grid--cell s-btn s-btn__unset c-pointer" title="This question does not show any research effort; it is unclear or not useful" aria-pressed="false" aria-label="down vote" data-selected-classes="fc-theme-primary" style="margin: 2px; box-sizing: inherit; font...
  5. R

    VBA code - saving of data in different excel file.

    Dears, I would like to kindly ask you for your help regards VBA code. Issue: I'm having very simple data entry form (kind of attendance list / evidence). I need to upgrade this code - currently data inserted to form are stored in different sheet of same excel file. I need to also save entered...
  6. W

    List(Sort by) Birthday Anniversaries in .txt file

    Hello people, I'm having a problem here, I'd like to filter the birthdays in the listbox and also know the "|" symbols. from the list and keep only in the .txt database. I would also like the EDIT, DELETE buttons to work. Follow the code so far and the download link. Thank you very much ...
  7. K

    help with 'advance to next record' code for button on userform

    I have 2 userforms in my workbook. One is for entering a record, and the other is for editing/viewing a previously entered record. I would like to add an additional commandbutton to the editing userform that will copy the contents of the form and then instead of unloading and exiting the...
  8. D

    Rename files with items from Listbox and textbox from Userform

    Hi all, Here is the code of the Userform I use If Me.répertoire = "" Then Me.répertoire = ThisWorkbook.Path nf = Dir(Me.répertoire & "\*.*") n = 0 Do While nf <> "" n = n + 1 ReDim Preserve Tbl(1 To n) Tbl(n) = nf nf = Dir Loop If n > 0 Then Me.ListBox1.List = Tbl...
  9. H

    Combo Box not showing Data and need to search sheets based on combo box

    Hello, I have created a user form that lets me enter data onto different worksheets within the workbook depending on a combobox selection. My problem arises when I click the command button to open the 2nd user form. It opens, but the combobox does not display the entries I want to Show. Sub...
  10. L

    With-End With

    Hi I have "dept" as ListBox and I am trying to initialize it using With-End With but I got compiler error. Thank you so much. Private Sub UserForm_Initialize() With dept .AddItem = "hr" .AddItem = "it" .AddItem = "marketing" .AddItem = "sales" End With...
  11. D

    Userform sum of selection of multiple listboxes

    Dear people, hope that all is well. I desperately need your help. Hoping to at least receive some feedback. So, below is the code. What I need to do is to have an If statement if the sum of the two selections of the listboxes is smaller/bigger than a certain value. I suspect it has something...
  12. V

    Userform formulas not working if updated

    Hello, I am creating a workbook where the user inputs data with 17 userforms. The first four userforms always show up. On the first userform I have 13 check boxes which determine if any of the other userforms are activated. If the checkbox is selected the associated userform will become...
  13. R

    Frames overlap

    Hi please consult. I have a UserForm and a Combobox interface. There are conditions in the ComboBox. which when they come true. TextBox appears in the frame. The problem is the one. that when you return in terms of conditions. Frames overlap. How to fix it? A snippet is attached. Private Sub...
  14. B

    Multiple dependant comboboxes with repeating list

    Hi, I presently have a coding that works but it is extremely long and I would like to know if there is an easier way (I am presuming yes) Present set up ComboBox1(ListProv1) -select a Province / ComboBox2(ListCity1) -select a City the list of cities will depend on the selection in Combobox1...
  15. U

    User Form Combo Box Not Filling?

    Afternoon all, As a VBA beginner, I'm currently having an issue with my user form where the combo box isn't populating with the options "I Shares" and "S Shares". I suspect that it may be an issue due to the start of the code in terms of the userform_initialize? If I'm being honest I'm not...
  16. C

    Userform ListBox - Remove Item in VBA

    Hi All, Not sure where I am going wrong. I have a userform and I want items within the listbox to be removed depending on the value of a textbox in the form. I currently have Private Sub UserForm_Initialize() NameTextBox.Value = Application.UserName With DepartmentListBox .AddItem...
  17. C

    Userform_Initialize Only Working Once

    Evening All, Could someone help me understand what I am doing wrong please. I am trying to create a user form (my first one) When I use userform_initialize it works the very first time I run the script. I then close the form to make some changes and next time I run the same script I get '...
  18. R

    How do i populate combobox with only part of table

    I want to populate combobox with the first 3 collums from table1 and the whole table from table2. But I also want my workbook to be dynamic, so I can move the tables around and not affect the userforms comboboxes. So far I have populatet the comboboxes with this code: With combobox1...
  19. K

    Populate Similar Value in ComboBox

    Is there a more practical way to fill 2 or more different ComboBox with the same value. so, I tried filling in ComboBox1, ComboBox2and ComboBox3 by adding items with standard codes like this Private Sub UserForm_Activate () With ComboBox1 .AddItem "one" .AddItem "two" .AddItem...
  20. J

    Combobox assign variable to selected value

    I have created a combobox called comboentity. Whatever the user choose in the combobox I want to be assigned to a variable called EntSel Private Sub userform_initialize() Call populateentities End Sub Private Sub populateentities() With ComboEntity .AddItem "253B" .AddItem "254B" .AddItem...

Some videos you may like

This Week's Hot Topics

Top