selects

I'm trying to figure out the best approach for this task; - user selects yes or no from a dropdown (or a check box would be nicer visually) - if user selects no, nothing happens - if user selects yes, a further 4 "questions" need answering, the possible answers should be from dropdowns not...

I have this code that does not appear to work as expected. If I select the name using the Dropdown arrow, it finds and selects the name in the sheet. However, when I type a name that is listed in the sheet, it selects the header. Whenever I type in the name, even though there may be a name...

I have a protected worksheet with locked cells. Will need to unprotect and worksheet when perform delete entirerow action. Is there any way to check if user selects entire row, right-click and selects delete?

I have run into problems using macros to control some actions in the “Rainbow Fact Challenge” worksheet. https://www.dropbox.com/s/8moydblnshrfm08/Beat%20the%20clock_ver%202.0.0.xlsm?dl=0 I do not know how to code in vba. All my macros I have ever used are either recordings or cut and paste...

I have a user form userform1) with a textbox (uf1tb1_wholeqty) in which the user enters a whole number, and a combobox (uf1cbx5_prtqty) from which the user is to select from a choice of four fractions (.00,.25, .50, .75) With VBA, I need to combine the two to make a number. eg uf1tb1_wholeqty...

Hi, Please can someone help me? I would like a vba code that selects cell D1 if the time is between 05:40 and 17:40, and if the time is between 17:41 and 05:39 then it selects E1. thnaks Dan

I hope someone can help me. I have a table in cells B2:m18. The column headers are months of the year starting with April. What I am trying to do, is populate a cell with some specific cell data from within the table base on two dropdown cells. For example if within sheet1 and within cell H4...

I have a dropdown in column B and i want to hide and unhide column based on dropdown selection . For example B4 - is my dropdown list and it contains numbers like 1 2 12 14 3 now based on condition if user selects less than 12 then it hides the H and I columns and if user selects greater...

Hello, I am looking to modify the below code in a way that when the user selects "Yes" in the drop down in cell A1, macro should just Exit sub. And when user selects "No" in the drop down the code should trigger "MyMacro". Private Sub Worksheet_Change (ByVal Target As Range) If Intersect...

I Know what I'm asking is possible, I'm just having trouble figuring out the correct rule set and formula to make it happen. Let's use this as an example. I have a simple drop down box that can indicate a Y or a N in Cell A1. if the user selects Y then I want Cell A2 to highlight itself blue...

Hi Team, I am using the following code to save a file with a new name Private Sub CommandButton1_Click() CommandButton1.BackColor = 5950882 ActiveWorkbook.SaveAs (Range("d4").Value & ".xlsm") End Sub When there is no existing file with the same name, the file is saved as desired. When...

Hello. So I've been working on a little project for a friend and it is almost done. The one problem that still remains is I would like excel to paste the contents of the cell the user selects into multiple sheets. However in the second sheet (Fhand) the contents simply keeps getting pasted...

Good morning, I'm stuck on this problem. Two drop-down lists. One is in A1 The other is in B1 User selects 'customerA' in cell A1, B1 should then be populated with data from worksheet 'customerA'!$A$2:$A If user selects 'customerB' in cell A1, B1 should then be populated with data from...

Good afternoon everyone. I have a macros which goes to a certain cell, and selects all the active cells to the right and below in the certain table. Range(ActiveCell, Cells(ActiveCell.End(xlDown).Row, ActiveCell.End(xlToRight).Column)).Select the goal is that it selects everything in that...

I have F12 and G12 as merged cells in an xls file that is exported from Navision. Clicking on F12 and pressing CTRL-Space to select the whole merged area (F:G), it selects a bigger area (A:J) because of some merged cells above F12. But if I click on the column letters F and G, I can select only...

hi have some code in my spreadsheet, that formats a certain area whenever i enter data into any area within. However although it works, it selects and moves the cursor away from the area I am working at . Anyone have a solution? KR Trevor

I have a Table I download often. I want to make a macro, which first selects the last cell in column H of my table. Then it selects the next cell in column H and inserts a sum formula for the cells in column h above it.

Hello everyone, I have the following code that simulates the user selecting the content (in this case, visible cells of a table column header): Range("Table2[Found]").Select Although, when this VBA code is executed, despite being originated from the recorder, it selects all cells, even hidden...

I have a combobox with dynamic dropdown list, but when i press the down key It selects a word from the dropdown list and then all the other options disapear(works as it should) Example: When i type "choc" I get the options "chocolata" and "chocolate milk" If i want to select the chocolate...

I have two options buttons in my sheet1 in B2. I have named the first option button (Radio Button) as 'Yes' and second option button as 'No'. What I want to see happen is when a user selects 'Yes', Cell C2 should be populated with a value and if user selects 'No', Cell C2 should be populated...