Search:

Type: Posts; User: Bagharmin; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    0
    Views
    350

    Changes in Timeline don't affect Slicer

    I have a Timeline and some Slicers connected to a pivot table. The pivot table uses data obtained via Power Query and loaded to the data model via a connection only (I'm probably not saying this...
  2. How do I use VBA to reference a table that only exists in the data model?

    I have two tables (Table1 and Table2), each on its own worksheet, that have been added into the data model. I created a third table (Table3) by appending Table 2 to Table 1. I chose "Only Create a...
  3. Replies
    1
    Views
    151

    Referencing a 'virtual' table

    How do I reference a table ("QA_Full") that exists solely in the data model and not on any worksheet? I know how to do it when the table is on a sheet (i.e., Set MyTable =...
  4. Clearing Slicer removes Pivot Table Value Filter

    I have a few Pivot Tables (with accompanying Pivot Charts) that have several slicers connected to it (all from the exact same data source). I've added a value filter to the tables so that they only...
  5. Re: Slicer problem - quick help needed please

    I tried that first and got the same result. So I deleted the slicer and tried again, still getting dates that would have been from last week's report (even though the source data only had the...
  6. Slicer problem - quick help needed please

    I have a spreadsheet I update each week. In it, I have a Pivot Table/Chart with a Slicer that shows the work dates from the past week. Normally I just refresh the chart and the slicer changes...
  7. Re: Trouble with ColumnHeads in multicolumn ListBox

    Never mind. I got it. I needed the RowSource to start with the second row instead of the first (which had my column headers in it). Once I did that, the first row was automatically added as my...
  8. Trouble with ColumnHeads in multicolumn ListBox

    I have a multi-column ListBox and I'm trying to add column headers to it. I've set the ColumnHeads property to "True". The data that I want to display is dropped onto a separate sheet and sorted,...
  9. Re: Some UserForm TextBoxes won't update when their values are changed

    And, to top it all off, I just re-sized a couple of the listboxes on the userform. Now the 2 that didn't function, function well, while two others now don't work. Once I noticed that, I...
  10. Re: Some UserForm TextBoxes won't update when their values are changed

    For each of the listboxes on the form, I have a short ListBox_Click sub which, eventually, calls the main sub where the offending bit of code is. Before any one of them calls the main sub, it sets...
  11. Re: Some UserForm TextBoxes won't update when their values are changed

    I’ve made some progress, in that I found out where things are going wrong (just not why).

    I have a formula (in column U) that identifies records that match the selections made in the userform...
  12. Some UserForm TextBoxes won't update when their values are changed

    I have a userform with 6 listboxes (you can select one option in each listbox) on the top half of the form. The bottom half of the userform has several textboxes that are supposed to change as you...
  13. Replies
    1
    Views
    116

    Re: HELP - Major pivot table help needed

    Never mind. I forgot there actually WERE macros involved, connected to the form Option buttons. I had re-saved the file as .xlsx instead of .xlsm. Problem solved.
  14. Replies
    1
    Views
    116

    HELP - Major pivot table help needed

    No macros involved. I have 3 (form control) option buttons that will change the data in 3 columns of my pivot table (there's a pivot chart that goes with it). Clicking on an option button will...
  15. Re: Nitpicking - Can I adjust the font size in a Application.GetOpenFileName dialog box?

    True. I was thinking mainly for other users, though. If it was up to me, everything would be in a nice 36 point font. ;)
  16. Re: Nitpicking - Can I adjust the font size in a Application.GetOpenFileName dialog box?

    Sigh. Okay. Guess it's time for the reading glasses.
  17. Nitpicking - Can I adjust the font size in a Application.GetOpenFileName dialog box?

    That's my question. My code for the GetOpenFileName dialog box is working fine, but the font for the Title is just too small for me. Is there a simple way change the Title font size just for that...
  18. Can I use an array as pivot table source data?

    Currently, my code takes data from the master table, creates a secondary table on another sheet, then refreshes the source data range of the Pivot Table and Pivot Chart that are on a 3rd sheet. I've...
  19. Re: Need help changing Pivot Table source data

    Never mind. I changed


    Worksheets("Pivot").PivotTable("MyPivot").ChangePivotCache ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:=CurrAddress)

    to

    ...
  20. Need help changing Pivot Table source data

    I have a Pivot Table that is based on data contained on another worksheet in the same workbook. The number of rows in the source data changes from time to time. I want to refresh the Pivot Table in...
  21. Re: Subscript out of range error when trying to save workbook

    Oh. So, based on my original code, it would have needed to be "Workbooks(FileName).SaveAs FileName"?
  22. Re: Subscript out of range error when trying to save workbook

    Thanks. I'll probably go ahead and do that, but, for my own education, can you give me an idea why I was getting the subscript out of range error when trying to save?
  23. Subscript out of range error when trying to save workbook

    I'm getting a subscript out of range error when trying to save a renamed workbook to my Desktop. Here's the code:


    ' Open the previous month's Report

    Filt = "Excel Files (*.xls*),...
  24. Re: Calculate end date based on in between workdays

    You could take a look at the WORKDAY.INTL function in Excel. That sounds like it would work well.
  25. Keep a shape from looking like it's selected

    How can I keep a selected shape from looking like it's selected? I've created an arrow shape:


    ActiveSheet.Shapes.AddConnector(msoConnectorStraight, XStart, YStart, XEnd, YEnd). _
    ...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4