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...
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()
If Range("B5").Value <> "" Then
Range("B6").Value = Evaluate("=VLookup(B5,SEARCH, 7...
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...
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.
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.