rowsource

  1. C

    Vba user form rowsource

    HI, user form search data from the same sheet,I want to get data from other sheet. need to change rowsource please help. sample workbook attached. https://sites.google.com/site/shoaibkahoot/ListBox.xlsm
  2. T

    Refresh rowsource of a listbox

    I have a range (Myrange) with three columns, the first two (eg Name, Address) are filled and the third (eg Age) will be filled through a form. So I made a listbox with rowsource (Myrange) and the user will select his name and then an inputbox will ask for a numeric value. The value is inserted...
  3. J

    Select Rowsource based on 2 criteria

    I have been using Case statements to create dependent drop down lists for combo boxes with success. I have a combobox dropdown to select appliance brand cmb.appbrand with pulls from rowsource= "Appliance_Brand". The very next drop down combobox is to select the color cmb.appcolor.rowsource =...
  4. kelly mort

    RowSource issue with combobox

    Hello everyone, I have a combobox called ComboBox1 with is populated by a rowsource. The combobox is on a userform. The issue is that I also have a listbox that populates the ComboBox1 when I click it. Since it (ComboBox1 ) was populated by the rowsource, I get an error when I click it. So I...
  5. A

    Filter UserForm Multicolumn ListBox with TextBox/ComboBox

    Hi Everyone, I've been looking for an answer to this specific scenario and I haven't found it yet. If it exists, I'm sorry for wasting your time and would request the link to that answer please. If not, here we go. I'm creating a listbox in a userform that's using a rowsource from a sheet...
  6. J

    Populating 35 Combobox Controls (Requesting Advice)

    I'm wondering what others might suggest for a project I'm working on. Quick project summary: I'm working on an Excel Front-End (Spreadsheet, Forms, VBA - the whole thing) with an Access database. The main form has a multipage control with about 35 total comboboxes. My question is related to...
  7. N

    Inserting Data into Textbox from Rowsource

    Hello: I am trying to insert selected Data from RowSource list into Textbox2 in Userform1. My Rowsource list has two columns and i like to have information from both columns be inserted into the Textbox2 with possible dash between them [12 12345 - Test Text]. However, i am only able to get...
  8. J

    Listbox Userform delimited rowsource

    Hello I would like some help with populating my listbox within my userform. My source data for the useform is in a single cell. Within the cell, each column is seperated by a | and every row is a carriage return (new line) So far I have: With Me.ListBox1 .Clear .ColumnCount = 6...
  9. J

    Help on refreshing multiple list boxes on a userform.

    So i have listboxes on a userform that display status of items at any given time based on data in an excel sheet(s) behind the userform. I can get all of the listboxes to populate/show status but to update these listboxes with new data every 60 seconds i have to exit the entire userform and...
  10. M

    Mac error 380 with UserForm ComboBox.RowSource

    I have a ComboBox what works great on Windows PCs, but gives me an error 380 on the Mac. The UserForm_Initialize subroutine has a problem with this line: cb_NodeID.RowSource = "Node!B2:B" & NLastRow In my test file, NLastRow = 371, so the RowSource will resolve to "Node!B2:B371" I tried to...
  11. F

    How to populate userform listbox rowsource from search results then use one result

    Hi all, I'm trying to use the results of a userform combobox search of a second workbook in the userform list box where I can then select one choice and fetch the contents of three columns in the selected row from the second workbook to populate cells on the first workbook. I'm stuck with trying...
  12. J

    Combo Box VBA code ?

    Hi All, I have one combo box supplying the row source to another combo box. I am using define range in the first combo box to achieve this. Everything is working well except for when combobox1 is blank or does not have a matching named range. Combo box 1 has a row source of sheet1!A2:A33...
  13. P

    Use AutoFilter results from NamedRange in RowSource ComboBox

    Hi, Been trying this for a long, long time now and I've yet to see a solution. I have a sheet with names of customers in column A. I also have a userform with a combobox. Its RowSource currently is the named range of all customers in A. I now want users to search for customers containing some...
  14. T

    Drop Box Row Source

    Hello, I am currently creating a form that will allow the user to select a portfolio, and then select an item in that portfolio using drop down menus. I have the Sheet being accessed set up in the following manor: <tbody> A B C D E F G 1 Portfolio List Portfolio 1 Portfolio 2 Portfolio 3...
  15. R

    Define Range using xlUP

    I'm trying to define the rowsource to populate a combobox on a form from a list in my workbook. However I can't manually input the range because the list is constantly being changed. Here is the code I am trying to use, which isn't working at all :) Sub populateComboBox()...
  16. R

    VBA Loops

    I have a userform with a listbox and option buttons that populate the listbox from a chart of accounts sheet. Right now my code works and this is what it looks like: Sub PopulateListBox() If frmAddAccount.optAsset.Value = True Then frmAddAccount.lbxAccountName.RowSource = "'Chart...
  17. R

    VBA Option Buttons

    I'm fairly new to VBA and have never used option buttons before, but I'm positive what I want to accomplish is possible. I have a form with a blank listbox and 5 option buttons. When the user opens the form and selects an option I want the listbox to populate based on the option button...
  18. K

    Combing Ranges in Combo Box

    A fairly simple task, but I can't figure out how to do it. I would like to have dynamic named ranges from multiple different sheets all combined into one combolist for users to pick from. ie combobox1.rowsource="Range1", "Range2", "Range3" (I know that is not the correct syntax) TIA!
  19. A

    Using Variables in .RowSource

    Hi, I have a spreadsheet where not only can the amount of rows increase but so can the columns being used. I need to reference parts of this area with a list box but am having difficulty in assigning cvariables to the rowsource. Private Sub UserForm_Initialize() Dim FinalRow As Long Dim FinalCol...
  20. D

    Listbox not refreshing using RowSource

    I have used this site to learn about writing macros from scratch and have found it fantastic but the for the first time I'm having a problem for which I can find no answer which probably means its me being dumb! I have a userform with a listbox that can be run from any of several dozen...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top