combobox excel vba

Hello! I'm still a newbie to the VBA and Userform usage. I have developed a Userform that will input the information from the Userform into the cells I have designated. I'm still trying to understand Arrays. But I have it setup in array for Vendor and Probe Type: Private Sub...

Hi, I am currently working on project that utilizes Excel and VBA. I do not have much experience in VBA programming. I am creating a user form that is designed to allow users to open multiple excel files (roster and qualifications). I would like the program to let the user to choose the files...

Hi, So I am here with a small problem. I have a workbook with a userform and in this userform I have a combobox where we choose from a list what sheet to open (i have several sheets in this workbook), in this i have an exit event that after i choose it goes to the sheet that I want. To...

I have discovered a very odd interaction and I am hoping someone can explain to me why it is happening. I have some code in a userform that populates comboboxes with values if you select a line of data from a list box and click on edit. One combobox populates with strictly numbers, all the...

I have a user form where there is a ComboBox that is meant for a number to be input, specifically the number of units desired. I am currently coding the error prompts if a necessary ComboBox is empty, and I want to add a check to ensure that the value in the Order Quantity ComboBox is an...

Hi I have created a user form with a number of textboxes . The Textboxes are pre populated based on an excel data base I would like to add a Combobox with properties of "Yes" or "No" in the drop down list. The number of rows is dependent on an end user selecting their email address and...

I have the following code that reveals a ComboBox when a target cell is double clicked Private Sub Worksheet_BeforeDoubleClick(<wbr style="font-family: Arial, Helvetica, sans-serif;">ByVal Target As Range, _ Cancel As Boolean) Dim str As String Dim cboTemp As OLEObject Dim ws As...

Hi Everyone I have the code below, which navigates to a website, clicks on a link on that site to open page, and then attempts to fill forms. When reches to dropdown list (or combobox) with getting errors. It all works except for the last part of filling in the dropdown list. If someone could...

Hi, I am creating excel macro for combo box in user form. I have succeed to create in single workbook. Here is my code in current workbook. ComboBox1.RowSource = "Sheet1!G1:G" & Range("G" & Rows.Count).End(xlUp).Row What I want to do now is, I want to get the value for my combo box from...

Hi All, relative newbie to VBA and MrExcel so gentle on me please... I have information in three columns (Dept, Supervisor, Employee) that I want added to separate combobox's in a VBA userform. Each employee can only work for one supervisor, and each supervisor can only work in one department...

Hi there I have dabbled a bit with VBA in excel but im not an expert, I have designed a form with the following: From, Destination, Product, Quantity, Carton Quantity, Costing road, Costing Air I have been able to link the combobox's to the cells on the worksheet (data). 1. Need to calculate...

Hi, I have a spreadsheet where sheet 1 shows a list of stores and dates. I then have sheet 2, where I have a created a combobox showing the list of stores from sheet 1. I am trying to write a code in sheet 2, where when I click on each store in my combobox it calls up the date from sheet 1 in a...

Hello, I am very new to VBA and excel, only started yesterday. I have made a table connected to a userform. The table contains information about a family, so a lot of information in a lot of different cells, but always on the same row. The userform asks for the user to enter the required data...