Data In Form Combobox2 Depends On Selection From Combobox1
Apr 25, 2014
I have it working as I need it to with Active-x combobox but I need to move to a form method because the Active-x combobox is buggy in the worksheet and has these strange font and box resizing issues which there is no solution to out there.. Something about if you have external monitor or projector plugged in and it using a different resolution to what your native laptop or pc is using.. doesn't make any sense to me and unfortunately I have given up on it.
Problem is what I want doesn't seem like it can be done with form combobox but I will seek your support first before I come to that conclusion.
So using form Combobox, this is my setup:
Combobox1 contains a short list of Teams i.e. ENT,MEL,EMEA,MTVSSL,TSJ -- I am referencing this from the FORMAT CONTROL property Input Range: TEAMS!A2:A6
Combobox2 I need to list the names of the people in those regions i.e. John Doe etc.. I have column with regions as headers and the people in each column in the respective region. i.e. B1:B16 has the list of people for the team called ENT (B1 is the header "ENT") and B2:B16 is the names of the people.
Problem is I don't know how I can link the two based on selection in Combobox1?
One catch, I prefer not to hard code the names of people in any code, if I can reference from a table or cell that would be better as the list of people within a team will increase over time.
combobox's.. I have it working as I need it to with Active-x combobox but I need to move to a form method because the Active-x combobox is buggy in the worksheet and has these strange font and box resizing issues which there is no solution to out there.. Something about if you have external monitor or projector plugged in and it using a different resolution to what your native laptop or pc is using.. doesn't make any sense to me and unfortunately I have given up on it.
Problem is what I want doesn't seem like it can be done with form combobox but I will seek your support first before I come to that conclusion.
So using form Combobox, this is my setup:
Combobox1 contains a short list of Teams i.e. ENT,MEL,EMEA,MTVSSL,TSJ -- I am referencing this from the FORMAT CONTROL property Input Range: TEAMS!A2:A6 Combobox2 I need to list the names of the people in those teams i.e. John Doe etc.. I have column with teams as headers and the people in each column in the respective teams. i.e. B1:B16 has the list of people for the team called ENT (B1 is the header "ENT") and B2:B16 is the names of the people.
Problem is I don't know how I can link the two based on selection in Combobox1?
One catch, I prefer not to hard code the names of people in any code, if I can reference from a table or cell that would be better as the list of people within a team will increase over time.
I have created two dynamic named ranges namely FolderName (refers to B column which has lot of duplicates) and WorkflowName(refers to C column).
For the first combobox, the dynamic named range FolderName is the source. So combobox 1 is populated with 2 values AUDIT, EPG. Here, my intention is "when i select AUDIT from combobox 1, then combobox 2 should be populated with the 3 values which corresponds AUDIT in the source worksheet.
I have a Database and user form, in the user form i have a field named “Vehicle No” this is a combo box from which a user needs to select the Vehicle numbers, and all these are working fine now, I need your help in the following:
When user selects the second field named "Select Vendor name" i need a pop up window which shows all the Vehicles belongs to the vendor which they have selected, and with the popup window user selects the vehicle number then the Vehicle number combo box should be filled.
Currently users have to select by scrolling through Combo box which takes long time and difficult to find by scrolling.
I have a form with Option Buttons and once a selection has been made it opens the relevant sheet on the workbook but I can get it to open the relevant form to feed that worksheet once the selection has been made from the opening form. Is it possible to do this and if so dose anyone no the code.
What I've done so far is... Created two buttons (Add and Find) in my Excel sheet1. If I click my Add button Form1 opens. In Form1 the user enters a number of values that are inserted into sheet2 of my Excel book. If I click my Find button Form2 is displayed. This form contains a multicolumn textbox that shows some of the columns from sheet2 that have values in them. Now to my BIG problem....
I would like to be able to select a row in my multicolumn textbox, click my OK button there and then Form1 should be displayed with ALL the values from that particular row from sheet2. As I mentioned I'm very new at this and I'm not even sure how to do this logically and much less the correct code for it. I hope that someone could thoroughly explain to me what I have to do and why to be able to get this working.
Private Sub UserForm1_Initialize() Dim rIds As Range Dim MaxId As Long Set rIds = Worksheets("Systemtest").Range(Cells(1, 1), Cells(Rows.Count, 1).End(xlUp)) MaxId = Application.WorksheetFunction.Max(rIds) With Me .IdBox.Value = MaxId Private Sub DateBox_Change() DateBox = Format( Date, "yy/mm/dd") End Sub.....................................
Using the Roy Cox Database code http://www.excel-it.com/vba_examples.htm , I am trying to populate a user form when the user selects a list row. I don't know if this is important, but I have extended my list beyond 10 columns. The list appears in UserForm2, and it should populate UserForm1. UserForm1 is also available to fill in from scratch; the info pulled from UserForm2 is from a search.
Here is my problem:
UserForm1 does not populate with the current selection, but rather the previous selection. It will appear blank upon the first selection. If I close UserForm2 after getting a blank on Form1 and call UserForm1 from its own macro, I will also see that previous selection.
I am trying to create a form to use as a golf tracker. I basically have created a scorecard where I input the date, score, fairways in regulation, greens in regulation and putts. I want to be able to put that information just like if it was a scorecard and then have a button that says submit. Then that information is output into individual sheets (i.e. one for scores, one for fairways, one for greens and one for putts).
I have set of user-form contains with Combox & 2 textbox and to generate report one cmd button
I have 3 different sheet contains report of daily activities ( Dispatch,Closed,Cancel)
If Dispatchcalls Select In Combobox1 ,Then Filter Start And End Date In Two Textboxes Then Click Cmd" Export Data To Excel"Extract Data from dispatchcalls Then Save Data Into Excel File As "Dispatchcalls".
If Closedcalls Select In Combobox1 Then Filter Start And End Date In Two Textboxes Then Click Cmd" Export Data To Excel"Extract Data from Closedcalls Save Data Into Excel File As "Closedcalls".
If Cancelcalls Select In Combobox1 Then Filter Start And End Date In Two Textboxes Then Click Cmd" Export Data To Excel"Extract Data from Cancelcalls Save Data Into Excel File As "Cancelcalls".
"C:UsersmaniDesktopNew folderLenvo_ReportsONSITE CasesVlokupuf" This is path i stored existing 3 file dispath,closed,cancel
I'm missing something in my UserForm initialization code. If I fill the form out once and click 'OK' (run the code to put the form data into a sheet), when I go back into the form all the old info is still there. If I then click 'Cancel' (Unload Me) and reopen the form, the old data is cleared out. What am I missing to make it clear it out the first time?
I'm having trouble trying to come up with a way to insert data fields into a spreadsheet form. I have a travel authorization form that I would like to have automatically fill in the required fields based on typing in a name. i.e. I would type in an employees name, and it would automatically fill-in the correct address, etc for that employee. I have attached a spreadsheet that contains one sheet as the form, and another sheet containing the employee data. I know nothing about VBA, but I have a feeling that is where I need to go.
I am needing to create a form that exports data (a quote) to an Excel Db (table) and is then able to recall the data back into the form. (the default form in excel does this and I want to copy that.)
Once the data is called back in, I can then export it to another Table to show that the quote has been approved and will be used.
I am having trouble with the VBA coding that copies the inputted quote in Cell C2 (the reference for the quote number) of the "Form" sheet and looks it up in the "Database" sheet. I have tried several variations of code, but nothing works so far.
-SS Sub RecallQuote() ' ' RecallQuote Macro ' Sheets("Form").Select Range("C2").Select 'this is the cell that holds the quote number to look up from the table
I have created a registration workbook for this year's youth sports league. All of the information is entered into a User Form and separated onto it's appropriate sheet designated by the child's age. Next year, I would like to use this year's workbook to look up returning players.
Will it be possible to add a "lookup" button into my form, or create a lookup program, that once the registrar clicks on the correct player, the information is plugged into the User Form, the registrar adjusts the age and any necessary info, presses enter, and the information is copied into the appropriate category in the new workbook? I haven't worked with User Forms long enough to know if they can be filled in that way, but if this can be done, you are the people who would know.
I have an excel table populated with 2 columns Date and Target where Target is a binary column which will be filled with either 1 or 0. I want to write a function such that if date is before May 3, 2014, then populate the Target column with 0. Otherwise, populate the column with 1.
I am analysing data to determine buy or sell transaction signals. The problem is that the method can and does produce frequent signals that are merely confirmation rather than new information.
Therefore, I need to select a signal, eg a "buy" signal where the previous transaction signal was the opposite, eg a "sell" signal.
In the attached sheet N10 is a valid signal as the previous signal was a "sell" signal. However, N14 is not valid as the previous signal was also a "buy" signal.
Currently, I am using a simple formulae to determine the signals, e.g. =IF(J26>0,J26,0). Hoevever, I need to modify this by looking back to confirm that a value >0 occurred first in column K rather than column J. If the value >0 occurred first in column J then I need to ignore the buy signal.
I am not sure if the formulae can be modified or if a macro is needed.
Whenever "online" appears in the "Desc" column I need to shift the matching row down (shaded area). for example, "online" appears in H2, hence, C2:E2 need to be shifted down to C3:E3 leaving C2:E2 blank. Next, H3 has "online" there, C3:E3 need to be shifted down one row so the result will look like the data on the "result" tab.
I have 4 checkboxes and if they are all unchecked then I need some text in the textbox. If even one of them is checked, then some other text in the text box.
Here is the code that I have been playing with:
Code: Private Sub TextBox2_Change() Dim check As OLEObject Set check = Sheets("Sheet1").OLEObjects("CheckBox1,CheckBox2,CheckBox3")
We have a need for formula that works out cost pricing but 1 of the items is based on the total cost excluding that item (VAT) and another is based on the total price (Cost of payment solution)...both are percentages of the respective factor. The way we have tried at the moment produces a circular formula...is there a way around this without a circular formula or a way to make a circular formula work to ensure profit is £0?
I would like to create a macro for my boss, their requirement is, in sheet 1 , they have one column, To chase . So when type "y" in any of the cell in a 'To chase' column, then copy the entire row and paste to sheet2.
Also is it possible to do this any selection change event of the cell?
I want excel formula to calculate the sum the value of partused depends upon serialno repeats where repeats of end of serial no i want result at end of every multiple serial no end cell.
I have a worksheet with three columns in it. the first column is the "channel column", the second column is the "status column"; which indicates the status of the channel column wheter it is active or not, the third column is the "circuit name" column which indicates the circuit name for each channel. now, the status of the channel depends on the value of the circuit name column.. if the cell in the circuit name column is blank, the status column has an if formula that automatically changes it to vacant status, otherwise active.
i added command buttons namely "active" and "vacant". this buttons correspons to active userform and vacant useform when clicked. in each userform there is a combobox. My problem is how would i fill the combobox in the active userform with the active channels only , and same in the vacant userform with vacant channels only. the comboboxes list should correspond to changes in the status column, that is if one channel gets an active status it would be deleted from the vacant userform and be added to the active userform
I receive real time data ( Last Trade Price ) of soybean commodity futures through DDE in to excel ( cell A1 ). During market hours A1 will keep updating every milliseconds or seconds. My cell B1 ( =A1 ) will have same value as A1 and will update at the same time.
What I'm looking for - A macro code so Whenever value in B1 is between 9.5000 and 9.5050, I want run a subroutine ( similar to calling a macro ). Since B1 would change dynamically so everytime B1 comes between range 9.5000 and 9.5050 a subroutine is fired.
I'm planning to CALL following subroutine - Sub BuyBeanst() Range("N9").Activate ActiveCell.Value = "Y" Range("T10").Activate ActiveCell.Value = "Y" Range("T11").Activate ActiveCell.Value = "Y" End Sub
I am trying to display number of lines which depends on value pass by user. Actually user is passing some value. on which some group of lines has to be display.
eg for 1 value 9 lines for 2 value first 9 lines + another 9 lines for 3 value first 18lines + 9 lines and so on till 52.(this 9 lines are set of some column and rows)
Firstly its probably best you download the file from below and open it up.
http://www.mediafire.com/?un3smhmdyzt
I need a formula to put in cells in column S on sheet March.
It needs to match up the correct price from sheet 'Container Price List'.
The price that should be displayed depends firstly on the account number, container and waste stream all matching to decipher which line the price is on. Then the price displayed should be the price in the column called 'exchange charge' however if this is 0 it should be the price in the column called 'rental charge'.
So for example, if you look at row 27 in sheet 'March' the price displayed would be £80.39. The formula will look at the account number 'c028' on sheet 'March' and match it to the any of 'c028' on sheet 'Container Price List'. It will then look at the container in sheet 'March' which is RL14 and match it with the ones that are RL14 in sheet 'Container Price List'. Then it will look at the Waste Stream in sheet 'March' which is GEN.C and match it with the GEN.C in sheet 'Container Price List'. The result given should be the exchange charge in sheet 'Container Price List' which in this case is £80.39.
If for example the exchange charge displayed £0.00 then the result given should be the rental charge in sheet 'Container Price List' instead.