selection

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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.
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. T

    How to create selection dependant comboboxs and define data source

    Hello, A forum contributer helped me create a dynamic array for 2 comboboxs which works great. Now I would like to understand how to either create a third combobox or set of third comboboxs based on the selection in box 2? Presently the first row of all columns is the title with the data below...
  14. G

    Delete all defined named ranges from a selection

    Is there a way to delete all named ranges from a selection? Here is the selection that I am trying to delete the named ranged from: Range("CompOverviewTable[[#Headers],[Competitor_one]]").Select Range(Selection, Selection.End(xlToRight)).Offset(-1, 0).Select
  15. Z

    VBA treeview

    I am doing the parent, child method on the treelist that i am doing on a workbook. The list of data i am trying to make into this list is extensive. I am looking for suggestions to the worksheet i am linking on how to either layout my list better or be able to select specific cells. The...
  16. I

    Chart based on Store selection

    I rarely post questions on here as I've so often been able to find posts on how to solve my problem. In this case, I'm struggling. I want to chart data based on the selection of a Store. How do I do this? <colgroup><col><col><col><col><col></colgroup><tbody> Gross Sales Oct-18 Nov-18...
  17. M

    VBA move selection to different sheet and insert based on selection

    Hi, I am working on below to move a selection of rows in sheet x given the string "Dead" to a next sheet (sheet y) and subsequently insert the amount of rows selected in that next sheet. Can anyone give an example how to show this in the code? Many thanks! Sub Moverow() Dim i As Long...
  18. E

    Selection Change Macro Error when Autofilter Hides Row

    I have a selection change macro in a file that updates only when the selection occurs in the "NIIN" column of values. The macro works fine unless you apply a filter (from the preapplied AutoFilter) that hides the row that is currently being graphed and even if I select a now visible cell it...
  19. A

    Report Lookup Data

    Hello, I am struggling with a solution to select data within cells and skip cells that are blank. The following is a description of what I have going: Group 1 - Book Size 6 cells in 1 row Cell shows the size based on selection made. The selection can require up to 3 sizes. Group 2 - Book...
  20. D

    How to only allow 1 listbox selection at a time?

    Hi, I have 2 listboxes (ListBox1 and ListBox2). When I select something in listbox1, listbox2 deselects and vice versa. I have tried these in listbox1 and listbox2 change and click events: ListBox1.Selected(ListBox1.ListIndex) = False and ListBox2.Selected(ListBox2.ListIndex) = False They...

Some videos you may like

This Week's Hot Topics

Top