combo box vba

  1. M

    Conditionally Show/Hide ComboBox Based on Cell Value

    Hi, I'm quite new to VBA, but I am attempting to get a Forms ComboBox to appear or disappear based on whether a certain cell (P7) reads YES or NO. P7 in turn updates in turn based on a user-selected value. As of now, the ComboBox only appears or disppears if I go back in and out of the formula I...
  2. U

    How to exit from user form's Initialize

    I have two userform combo boxes, the second follows up on the results of the first. The second Combo Box looks for incomplete fields and provides them in a drop box. If the data the second Combo Box is looking at (This is different data than the first Combo Box is looking at.) is complete it...
  3. D

    ComboBox Linking to multiple cells in column

    Help! I have gotten to a point of partial success (much to the thanks of subscribers to this forum!) but am now stumped. I need to have a single combobox pull values from a very large term list (>40,000), and place selections in a single column in sequential cells (eg, B1, B2, B3, etc..). With...
  4. E

    Combo Box Properties Changing

    Hi, I create a combo box using the following: If CheckExists("cmbBaseD") = False Then With ActiveSheet .OLEObjects.Add(ClassType:="Forms.ComboBox.1", Link:=False, _ DisplayAsIcon:=False, Left:=159.75, Top:=80.25, Width:=75.75...
  5. S

    Populate Userform with Data from External Workbook

    I have the following code in my combobox1 on a userform. Is it possible to populate the combobox with data from another workbook (on another drive)? I tried putting in the path of the workbook but that doesn't work. Any help is appreciated. Thank you. Dim strFind Dim rSearch As Range 'range...
  6. L

    conditional userform data

    Hi, I am tottaly new with the userform and hoping if someone can kindly help me figure the following out pleaseeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee... (meow face) I am using a userform with text boxes and comboboxes for users to enter the data. Than I am using following to feed the users...

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