selected

I have the following which seems to reset comment/note boxes only when the red indicator is hovered over: Sub ResetComments() Dim cmt As Comment For Each cmt In ActiveSheet.Comments cmt.Shape.Top = cmt.Parent.Top + 5 cmt.Shape.Left = _ cmt.Parent.Offset(0, 1).Left + 5 Next End Sub However...

Hi All, I have a drop down with 4 options, depending on which option is selected the corresponding sheetname would be selected and column A would be copied to the clipboard. e.g the dropdown values are as follows ebay, amazon, otto, tesco and the sheetnames are the same Any idea how this...

hi all a tricky one for me here:- a vba solution to stay 5 secs on each sheet and then loop back to the first tab like a slideshow The problem is I only want certain sheets to be showing on this slideshow - which I can hide or have selected in a list ? these sheets have specific names too :-)

I am no able to find out how to highlight the source data values for a value selected in my pivot table. e.g. if I select a value (say 57111.25) in my pivot table then all the values/rows in the source data whose sum is that value (57111.25) should get highlighted/colored/numbered. There is a...

Hi all I am westling with a date issue in vba, I know it is to do with the way excel manipulates dates, but I just cant get there. I derive two strings from a user form input, one is the month (selected from a list Jan to Dec) and the other a year in two digits (from a list from 15 to 25...

When a particular data is selected from a list ,corresponding values should be filled in adjacent cells. For example, When Class-I is selected ,different Fees related to that should be filled in adjacent cells. Example <colgroup><col><col><col span="2"><col span="7"></colgroup><tbody> DATE...

I am trying to fire a macro only when the cell value inside a specified range changes (i.e. not selected but actually changed in value). I am using this code but it fires every time a cell is selected. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not...

Please help me out, When a particular data is selected from a list ,corresponding values should be filled in adjacent cells. For example, When Class-I is selected ,different Fees related to that should be filled in adjacent cells.

Hi, I Have a piece of code below which loop searches an array for a specific string, once found it selects the cells which contain the text and loops until finished. What I want to do now is copy the selected cells and paste them to another workbook but I'm having difficulty. Any help will...

I have a cell with a drop down list in it and I want a message box to appear when a certain option is selected from the drop down list. I am pretty sure you can do it with vba but I don't know the code to do so. Can someone help me please?

I want all cells in a worksheet to expand after every input as if you had selected them all, then double clicked the grid line to manually expand them. Thanks in advance

Hi team, I have a problem, i can't resolve it. I want select manuell a part of data (variable) and run macro. Macro should copy the first cell (top-left cell from selection) to Z1, and copy the selected data to sheet2. How can i do that ? regards

I have two tabs in a file. One tab has different facilities and their associated metrics (8-10 metrics). Each metric value is conditional formatted using color schemes option. The second tab is a report which has a drop down to select a facility. Depending on the facility selected, all their...

Can anyone help me in this, tried to find a lot but couldn't. I need a macro to duplicate few selected cells (rows and columns) to be duplicated for x no of times keeping a row gap after each duplicate. Similar to the link below but not single row or column , needs to be for selected cells...

is there a way to once you put a sheet under Hide have it only viewable to admin users. or put a password on that sheet so one other then yourself or selected few can view it?

Hi all, I have created a userform, There are 2 conditions The 1st condition with optionbutton1 and obtionbutton2 (they represent either ''Male'' or ''Female'') The 2nd condition with optionbutton3, optionbutton4, optionbutton5 and optionbutton6 (they represent ''less than 18 years old"...

I have a worksheet with Customer Information. In Columns D-T is the Customers information Headers address, phone, email, etc. In column D are the Customers ID #'s I would like to take the Customer ID# for the selected customer and show it in Cell B2 . Is there a way to do this? I have attached a...

Having a lot of issues trying to resolve this problem. so i currently have 3 league tables. each league table is then automatically changed depending on the options selected from some drop downs. shows the sales of staff at a particular site. You have an option of new sales, used sales and...

Hi, I have a drop down for Month name as well as a Current Year. Looking to use these to return eomonth based on month and year that are selected. Is there a formula that would be able to do this? K12 = Month K13 = Year. Thank you Sorry to clarify I would like the output to be if May 2019 is...

I have written the following code to select files to be copied once I select a file it appears in the message box I would also like the file name selected to be copied into Col A from row 2 onwards on sheet "Macro" or e.g. if BR1 sales May 2019.csv is selected first, BR2 sales May 2019.csv...