choose

If I have 5 or more combobox in a userform and all have the same rowsource, but I want if i choose a value in one of them that prevents their appearance in the others ?

ı am new vba and here. I am working on stocks and ı need your helps. so firstly as you can see on tittle, ı want to choose automaticly in down list what i write on my excel. So ı need amortization information from this web site website in "MALİ TABLOLAR"page amortization in turkish is amortisman...

Hello, i have a problem with drop-down list - my goal is to create two lists like: I choose value in cell a2 and excel shows concrete value in cell b2. This is simple. But how to make excel to make it both way. A2 choose "data" - display in b2 "excel" b2 choose "execel" - display "data"...

I have a list of names in col A and a list of numbers in Col B. I have a drop down to choose the names with. In a different cell, I want to subtract a number from the number in col B that relates to the name chosen. So if I choose A1, I would subtract the number from col B1.

I am hoping some one can help me with a perplexing problem. I am using Excel 2010. I have a worksheet with a range of data ... including the header row, there are 16 columns and 251 rows (B8:Q258). I have selected Data / Filter to enable the autofilter arrows in each cell of the header row...

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> VBA, which can choose "x random numbers" from a list of column A (list in the column a can be max 290 rows)</SPAN></SPAN> For example list shown in column A has 28 rows, I want "4 random (no duplicates), which I have placed in cell B1 and...

Hi all I want to have macro code to do that: Brown to folder to choose excel file, copy sheet(array("source1","source2","source3","source4") then paste in active workbook with sheetname changed to sheets(array("A","B","C","D"). Thanks in advance./.

Hello kings of the formula i need a formula to choose the largest value of the cell 1

Hello! How can I count all the cells in a specific range that contain in their text a specific word? If it is easier, we can choose the cells that 'start' with a specific word (that would also be applicable). Can I use COUNTIF with wildcards? Thanks!

I'm tryin to return a value above the searched row. I've tried a couple options and here is what I have tried: =HLOOKUP(LEFT(Y4, 4), CHOOSE({1;2},B3:M3,B1:M1), 2, FALSE) =INDEX(A1:M3,MATCH(LEFT(Y5,4),A1:M3,0),MATCH(LEFT(Y5,4),A1:M3,0)) =VLOOKUP("AISLE", A1:M3, MATCH(LEFT(Y6, 4), A1:M3, 0)...

Here is the Sample that I will be referencing: https://www.dropbox.com/s/qsnzojulgipugma/Test.xlsm?dl=0 In this financial planner, I have data in sheet one that gets moved over to sheet 2. When this happens, it auto updates the text to remove all the repeating data. (card number). I have made...

Hi Guys, I have similar question and I was hoping someone can help me with it as I am trying to develop my VBA capabilities. I have an excel file that will hide and unhide based on multiple values which mainly year and month criteria, meaning: if it is 2016 chosen then all the columns of 2016...

Hi, I want to be able to click on cell "B5" which is called "delete" and rhen be able to choose which cell I want to delete the value in. How do I do?!

I have a listbox on a userform that populates a textbox with the PO number when I click on a row in the listbox after scrolling through the list. The issue I am having is the textbox will not update IF I choose the 1st item in the list, it works for all other items. Is there something I have...

good afternoon, After several failures I still have an issue and hope some kind member can help? i would like to generate a message upon opening the applicable file that would ask the user if they want to input data into another worksheet (within same file) & choose Y or N if yes , a input...

I have a front sheet in Excel that is formatted in a colour (say yellow). Sometimes when I do certain actions (such as choose an item from a drop down list in the sheet) contents of other sheets start to appear. They disappear when I scroll away and back (or choose a different sheet and come...

Hi all, I have created condition based drop-down lists (Equipment tree for production line) so that if you choose line X, you can only choose from section Y, an so on. Now I want to create a matrix that also is condition based. So if I choose Line X and Section Y, certain cells should get...

Hi Everyone, I need a macro that opens up the file explorer and lets me choose the document i want to open, then copies range A1:Z & last row, and pastes it into the document the macro is run from sheet "new Data" A1 please help if you can Thanks Tony

Hi, I want to use the choose function in VBA, but it doesn't seem to be working. my code... xx = Application.Worksheet.Choose(1, "3", "4", "5") thanks

Hello This is a non-VBA Question. I have a Pivot Table with 2 row labels (Name & ID) and 3 SumValues (A, B & C) I want that my Pivot show only values that are: C > 0 A > 2.500 Once I choose a value Filter for C greater than 0 I can no longer choose A greather then 2.500 I can only add a...