I have been researching and have gotten close but not exactly what I need. Please help me code with the below in my first Userform.
Combobox #1 - Named "ComboBoxlLocation"
Combobox #2 - Named "ComboBoxCopy"
Combobox #3 - Named "ComboBoxMedia"
Combobox #4 - Named "ComboBoxPricing"...
I'd like to alter what populates the second combobox depending on the selection of the first combobox.
The first combobox is populated from a table range with company names. This is on a userform.(dictionary stops multiple repeats)
the second combobox is created at run time and populates from a...
Hi, I have a Sub which selects an Excel file by dialog box. On selecting the file, a TextBox (Besides the Browse button in Userform) displays the full path of the selected file. Now There's also a Combobox below that textbox in which I want to populate all the Sheet names which are there in the...
Hi,
I have 2 workbooks. One is the macro workbook, the other a source list. the macro workbook will be used for storing header data from the source and then later, formatting the source workbook correctly.
During the procedure that opens the source workbook, the macro searches for a matching...
Hi all
I'm new here and new to VBA programing.
I've created a combobox that show a list of "criteria" based on a user selection. It works the first perfectly time, but when the user select a new project which changes a cell where the combobox looks up for selecting the right list, the combobox...
Hi
I want to create two combobox to both selectable and value of them fill automaticly when select value on another combobox, then I write for Combobox1:
Private Sub UserForm_Initialize()
Me.ComboBox1.List = Worksheets("Sheet2").Range("B2:B600").Value
End Sub
AND
Private Sub...
I am new to VBA and working on a userform but am ready to pull my hair out with something I fear is very simple. I have a combobox (Cntrl2) that I want to populate with manager names. I have a range titled DMNames that I set as my rowsource property for the combobox. This works fine and when...
Hi everyone,
Ive been struggling with this for 2 days now I could really use some help.
I have the following problem:
Ive got a sheet1 named "initial" in wich ive got a bunch of buttons that open up different userforms, before the user is able to press the buttons he must choose between 3...
Hi All. I have a VBA form with comboboxes on it which I currently have looking at a range of data to populate it. All works well like that but I want to change it so that it looks at a non-contiguous range.
e.g. will need to look at c5, c23, c31, c40 etc for a "y" and then look in the...
Hi,
I have the below snippet of code which is creating a unique list for a combobox on a form. It works very well to provide me the unique list of values from column "U," however I would like to include the associated Values from column "M." I have read through a number of posts on this topic...
Hi all,
I have something like the table below and I need to fill 4 comboboxes and 2 TextBoxes with these values:
Combo1 = Directors level 1
Combo2 = Directors level 2
Combo3 = Company
Combo4 = CostCenter
TextBox1 = HeadCount JAN 2014
TextBox2 =...
Hi Everybody. I am trying to call a public range to use as the data source for my combobox drop down list, however I continue to receive errors. I found some code that worked by declaring the range variable within the UserFrom_Initilialize() but I can't seem to transfer it over to what I would...
Hi
I have a table with 3 columns: Products, Location and Quantity. I created a userform to add new products and the code runs fine. Still, I would like my userform to do the following:
-if someone tries to add a product and that product exist in different location, I would like to view those...
Hi All,
I having a problem with a run time error code that occurs when I attempt to copy and paste data from one worksheet to another sheet.
basically I have 3 sheets 1 sheet (sheet1) is used for data entry, the op enters int various cells and textboxes by pressing a command button which...
I have created a workbook with a lot of userforms which is going to be used to collect answers about software configuration from my company's customers. I use multiple list boxes and comboboxes on each userform. Yesterday, I was working on one of the userforms and I ran it to see if something...
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.