userform combobox vba

  1. C

    Can I use a userform/combobox for both selecting and adding?

    Hi to all, Complements to this website for giving me the answers I seek consistently. My question is very basic but want to follow accepted procedures and practices. My userform contains name, address, and email. Name is a combobox and contains over 4000 names, other fields are textboxes. I can...
  2. T

    Userform Functionality: How to Use a Combobox to Specify Which Worksheet Data is Pulled From/Entered Into

    Hello there, I am designing a userform which enables me to search a workbook with several worksheets containing contact details for different types of organisation. There are five worksheets that I want to include in the combobox for the 'Update' tab, but there are a number of worksheets...
  3. D

    using one combo box to auto fill others!

    Hi Sorry if this question has already been asked I've spent several hours searching and not found what i need. I'm looking for the vba code to use to auto fill other combo boxes when the correct data is selected in one of the other combo boxes on a userform. this is what i would like to...
  4. C

    Dependent Drop Downs in UserForms

    I'm trying to create a userform with dependent drop-down lists in it. I'm trying to populate these lists from various tables that I've got saved in a couple of sheets. I know how to use dependent drop-downs within the spreadsheet, but I can't find anything on how to do it within a userform. The...
  5. E

    Using a Variable to Reference the Name of a ComboBox in Form (And Loop)

    Hi all, I'm working on a loop that will look-up and place values (text or numbers) into a collection of combo and text boxes in a Userform. I have 75 comboboxes and 150 textboxes in the userform (2 textboxes under each combobox). Lets say the name of the comboboxes are as follows: Cbox_1...
  6. M

    If 3 userform comboboxes are changed, run macro

    Hey guys, I thought this deserved a separate thread after Mike Rickson helped to solve 2 comboboxes changing. Does anyone know some code which fires a macro if 3 comboboxes have been changed? Thanks Mark
  7. A

    Userform macro - output into specific cells

    Hi, I'm building a new document where user using userform1 writes data from textboxes into a new row of table (e.g. name of client, address, etc.). This userform1 works fine, but there is a userform2 for adding additional data, where user selects a name of client from combobox. On the basis of...
  8. K

    Userform will not return desired date format into textboxes

    Hi Experts I have been through so many potential breakthroughs in the past week via the net/forums/handbooks etc but cannot for the life of me find the exact code needed to return "dd/mm"yyyy" to my textboxes when i intend on updating exsiting data within my form. Basically I have a textbox...
  9. D

    Multiple combo boxes refenrencing the same range/list without repeating choices.

    Hello! I hope someone can help me. I am desperately trying to accomplish the following; I have an userform(FormEntry) with 6 combo boxes. However, all 6 combo boxes reference the same range(Courses) under column "C" in sheet(Ranges-Lists). What I need is for the boxes to continue referencing...

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