1. D

    VBA Make pull-down trigger Change Event to put text on another sheet

    Hi All, Here's one I can't seem to figure out. This code is to effect 2 sheets in this Excel 2016 workbook, "ROW" and "Project Summary". Column D of the ROW sheet has a pull down with a data validated list. One item in the list is "Pending Approval". Column E has the variable string "CIR" which...
  2. S

    pulldown keeps pulling down?

    Hi There, I have an google pulldown menu that works fine, but when I select an other cell I keeps pulling down? hereby my code, what am I doing wrong? Private Sub ComboBox_Change() ComboBox.DropDown If Range("B5").Value <> "" Then Range("B6").Value = Evaluate("=VLookup(B5,SEARCH, 7...
  3. H

    How to obtain MAXIF VALUE and its corresponding adjacent cell?

    Hi guys, I am struggling to come up with a formula that will be able to obtain the MAX VALUE of Column D and the its corresponding cell to the right. e.g. for my deadlift, i want to use 130kg and return the number 5 (reps) in a cell, or for lat pulldown I want 55kg and 7. Any help would be...
  4. J

    Subtracting various cells from one constant cell

    Say I have the number 325 in A1. Each time I type a number in A2, B2, C2, D2, E2, A3, B3, etc... I would like the number (325) in A1 to be reduced. Also, how do I create a pull down list? Thank you for your time.
  5. S

    Resize pulldown menu

    Can the pulldown menu be resized? I've seen it done but don't remember where so I think it's doable but don't know how or where. I do not want to change the cell size just the pulldown. I've seen it where the user can drag the corner of the pulldown to resize it. Thank you, ~Sreyes

Some videos you may like

This Week's Hot Topics