1. A

    VBA Hide rows based on button selection

    Hi Please some one help me to find the solution for the below question? I have 2 sheets called Buttons and Database as shown in the below image. Upon button selection I would like to show only selected Name/Skills in Database sheet. eg: If "Dinesh" button selected show only Dinesh rows in...
  2. E

    Include the value of a Cell in a SUM based on the selection of a radio button

    I am looking for a Formula that will count a price based on the selection of a few Radio Buttons. So for instance =SUMIF(B1+(Radio selection 1=1, then add B2, if radio selection 2=1, add B3...etc I know this isn't the correct use of SUMIF but this is the essence of what I am trying to achieve...
  3. Y

    VBA: Select rows two by two ?

    Hello, I have an exported, filtered list of results (not a table) where one out of two rows (the second one) describes the first one. Now I'd like to select these pairs of rows dynamically in order to format their borders, among other things. I'd like, for instance, to give the impression of...
  4. B

    Worksheet_SelectionChange event not firing !?!

    Hi all, Worksheet_SelectionChange event doesn't fire if I change the selection from a cell to an image. Does it only fire if a cell is selected (it seems to be the case, but I thought I'd check)? Option Explicit Private Sub Worksheet_Activate() Application.EnableEvents = True End Sub...
  5. Y

    Clear content of cells outside area of interest

    Hi all, I am looking for a way to clear the content of all the cells outside my area of interest (designated by the orange oval): Close up, it looks like this: I would like to clear the content of ALL the cells that are not encircled, and including those coloured in orange. How can this be...
  6. J

    Spreadsheet Navigation aid

    A while back, I used bits and pieces of code to cobble together a macro that selected, not highlighted, the current column and row of the active cell as I needed any range customizations to be unaffected. It involved, of course, the Worksheet_Selection_Change event. But it also involved a Class...
  7. M

    Randomly Select Based on a value of another Cell

    Hello- Trying to create a formula that randomly selects a tracking ID for each associate. In addition, make an alternate selection, but it can't be a duplicate of first random selection. Was thinking a VLOOKUP & RANDBETWEEN combo, but stumped. Not sure if I have to go through VBA route? Any...
  8. M

    VBA Multiple selection (selection with CTRL)

    Hello, I'm trying to write a macro that copies all selected cells and paste it somewhere els. My problem is with the selection part. I'm using: Dim CopyRng as range Set CopyRng = selection The problem: If I select multiple rows with the CTRL hold in, it only copies the first rows. Example...
  9. A

    VBA rows selection leads to "selection wrong number of arguments or invalid property assignment"

    Hello! I'm trying to write a simple macro that will delete few rows, than sort by values from one of columns and than delete few rows below some value. I am using the strings of the code just strictly from "record macro" function. It does have codes like rows("1:6").Select or...
  10. lockarde

    Make userform open at specific cell

    Good morning all, I have a macro that runs when a user double-clicks a cell. Among other things, this macro opens a userform. Is there a way to make the user form open to the right of the double-clicked cell every time? The location of this cell moves down the sheet as the user activates the...
  11. D

    Selection to the Left (plus/minus 1)

    I am having a similar struggle as the OP in this thread, except in mine I am trying to go to to the left, minus 1 (or would it be plus 1?). I basically just want to start at FM8 and select all the way left, then move the selection to the right one column. I recorded the macro to try and get...
  12. A

    VBA for total and subtotal

    Hello, I have a spreadsheet with column I where there is a lot of data. I have the 1000 which is the sum of the 2x500 (bold) The 2x500 are the sum of the data (first one is 200 =300 and second one is sum of 5x100) I would need a VBA that would populate the formulas taking in consideration the...
  13. M

    Macro to print different Worksheets in separate printjobs based on user selection

    I have a workbook with different worksheets. As these have different orientations you can't simply select and print them, as the page orientation is the same on all of them as on the first page. Now I would like to create a macro with which I can print the selected pages (which are not always...
  14. gheyman

    Yes/No Message Box

    I would like to add a pop-up Message box that happens in this code after the DoCmd.RunCommand acCmdSaveRecord. "Do you want to return to the TSL?" If Yes then then DoCmd.OpenForm "frm_NIS_TSL", acNormal, "", "", , acNormal If No then the DoCmd.GoToRecord , "", acNewRec command Any help is...
  15. V

    Is there any way to change range's values more efficiently than looping?

    I have a range of cells with values inside. The values have pattern such as '123-abc'. Now I need to change the value of selection to just 123. I currently use left function to loop over the selection. But it's very slow because I have 1000 cells.
  16. H

    VBA Selection

    Hello Friends, Is there a way to move the selection to the second column of that same row. Like if the selection (target cell) is lets say column H32 then I would want the code to make the selection to B32 or if the selection (target cell) in on A15 then i would want the code to make the...
  17. E

    Help with monthly average

    Hello all, after hours spent trying to find a solution online, which was unsuccessful, I decided to post a new thread and see if anyone could help me out. I have multiple pivot tables connected to timeline slicer where user can select time period to view data set. I found online how to get...
  18. Darth_Williams

    Data Validation - Lists

    Good afternoon all, I am looking to to list data validation over different columns but have it so that the selection in the first column will only show a certain selection in the second. So column A will show a certain supplier then column B will only show what that supplier provides, Column C...
  19. diddi

    Combobox Text behaviour

    Morning All! I have a minor but irritating problem with UDF comboboxes. I need to display a long text item for user to have correct information in selection, but do not need to display it all after selection. my annoyance is that after selection the content is always displayed right justified...
  20. D

    Upon selection of item in table row, need msg box to appear and have resulting number entered in table

    I have a table called npss_quote. The header row is A10:M10 with the data starting in row 11. Column B for each row in the table has a data validation list referring to a list of 7 items. Upon the selection of one of the items, Activities, I want a pop up msg box to appear. This allows you to...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back