.additem

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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