selected

I am using an inputbox to have a user enter a month( Jan - Dec) The months are in Columns B:M in row 1 I need to know the column number of the selected month. I've tried match and it seems to be failing me. any ideas?

I am trying to figure out how to reference individual column filter criteria in an IF/Then statement. I was able to use AutoFilter.Filters(CF).Criteria1 where CF is a variable for the column. Using this method, though, if column A has a criteria selected, then column B shows up as having a...

Hello, I have the code below to get the lookup amount of the selected client from sheet5, but I don't know what I did wrong since it's not showing the amount on the "txtTotal, can you please help me to get the amount of the selected client? Note: the Amounts on column "D" contains formulas...

Hello All, This is what I need to do. I have a drop down list in sheet 1 that when a customer name is selected I want to copy in just the selected data for that customer name from another worksheet. I do not want to see all the records just the records associated for that customer. I've tried...

Hey everyone, here's what I'm trying to do. Whenever a cell in row 5 is selected, highlight the column in a specified range. I've used conditional formatting based on a formula, =COLUMN()=CELL("col"), and the following VBA code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If...

Hi I selected cells A1:A20. They are all selected and the active one now is A1. I can make A2 as an active one without losing the selection by pressing Tab key, I can make cell A10 as an active one by pressing tab key as well. My question, if A10 was the active one. How can I go back to cell A1...

Hello, I have below piece of code in sub that copy a range and paste the selected in another range, it works fine but how can I make it to copy and paste the selected as values and formats I tried to use ".Paste" but I got an error Sheet2.Range("Sales_List_All").Copy...

When I select any number of adjacent cells (could be in a row or a column), anywhere on my spreadsheet, I would like to then press a form control button that will fill the interior color with color the 16738047. I have tinkered with several codes I've found online, but so far they only color...

Hello all, A1 on sheet Log, will be a Month and Year only (Mar 2019) A2 Should be first day of the month selected in A1, Col A will have all the next dates of the month until the last 31st But what I would like is if I select Feb 2019 in A1 all the col A fill up until the 28th Feb (Cell A29)...

Hi - I'm trying to figure out how to write VBA code to insert a specific formula across a random selection of cells. The gist of it is, that for whichever cells I have selected I want the code to write "= [EXISTING CELL VALUE] - adjacent cell". My VBA code works as long as I only have a...

Is there a macro or vba code i can use so that when cell C6 dropdown is selected, a message box appears for the user to insert a comment mandatory? I would like to use this for multiple cells i.e. cell C6 dropdown 'Resource' is selected, message box appears saying 'Insert Comment'...user...

Hi All, I have a large workbook that has a sheet which calculates results with and without inflation. I have code that changes inflation to 0 and then back to what it was originally. Before I copy the original assumptions back I need to calculate just one sheet that is selected in a drop-down...

I have two columns that the user needs to update. One column is a checkbox (actually a wingding font) and the other is a cell with free data. I want them to be able to double click on the checkbox cell but not enter any data. I want them to be able to click on free data cell and enter data. I...

Hi All I am hoping somebody can give me some help. I have been working on a word document which I am going to transfer into anExcel spreadsheet. In the organisation that I work, there are a number of services that useoutside Networks for accessing data. More than one service can use the same...

I am using excel in this office 365, not sure if it is technically excel 2016 or what. I have a long string of numbers and when I highlight and scroll with the objective of getting the numerical count it is deleting my data in the first selected cell and attempting to add it to the last selected...

Hi All. I created a user form with multiple toggle buttons. Each buttons represents a sheet in the spread sheet. I would like to be able to only print the pages of the buttons that the user selected. At first I tried to use the respective click button subs to select the sheets. It only select...

Is it possible to either return the Label Selection or the periods selected from a Timeline attached to a pivot table?

I need to determine if the cells that a user selects are consecutive, in terms of the rows. I have been trying to write a function to determine this (and return either TRUE or FALSE), but I am having a very hard time figuring out how to do it. I know how to get what cells the user has...

Hi guys, I am trying to copy selected items from a multi-column listbox to another (At this stage I want columns 1,2 and 5 copied across to columns 0, 1, 2 in the second listbox on a separate userform). I have written the following code, however it is only showing the last selected value in the...

I have the bellow code Range(ActiveCell.Offset(0, -11), ActiveCell.Offset(0, -20)).Select I need to hide entire colums that contains selected cells