Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Re: Multiple Charts from One Pivot Table Without Loosing Pivot C

    If you record a macro while setting the formatting, you should be able to place that code in the Worksheet_PivotTableUpdate subroutine and tweak it to your specific needs. That way, any time the...
  2. Re: Excel chart: group by month, cluster by department, stack by type

    Apparently not, I guess Google Photos doesn't work as an image hosting site. I tried making a crude representation out of typed characters, but all the white space got removed when I hit "preview...
  3. Re: Excel chart: group by month, cluster by department, stack by type

    I'm not sure if this is going to work, but here goes....
  4. Replies
    14
    Views
    119,687

    Re: Plotting grand total on pivot chart

    I'm trying to do something similar. Basically my pivot chart is clustered by month, but in the axis label next to each month I'd like it to display the grand total for that month. Is that something...
  5. Replies
    3
    Views
    10,984

    Re: Export multiple Excel Sheets to PDF

    Looks like I'm almost a decade late to this party, but I just finished putting together a sub that exports all visible sheets to a single PDF so I thought I'd share it here in case others come...
  6. Re: Cancel printing based on another macro

    That did the trick, thanks! I'd heard that method mentioned elsewhere, but I think seeing an example really helped. Pretty sure I just had the syntax of the function wrong when I tried it before, so...
  7. Excel chart: group by month, cluster by department, stack by type

    I'm sure I've got some of the terminology wrong, but here's basically what I'm trying to do. I have a table of data with three fields I want to use in a chart: date issued, department, and type.
    ...
  8. Cancel printing based on another macro

    I've got a subroutine 'Print_Report' that calls another subroutine 'Check_Fields' and basically, if certain cells are empty then 'Check_Fields' exits the subroutine, but 'Print_Report' continues to...
  9. Re: Is there any way to check whether an option button has been checked?

    That was it! So it looks like I needed to account for the fact that I was using ActiveX option buttons, and once I did that I was just forgetting the ".Object" portion of the code. Thanks!
  10. Re: Is there any way to check whether an option button has been checked?

    The worksheet is just named "Sheet1" and the option button is named "OptionButton1"

    Here's my current code. I've been testing your methods by just looking at one option button instead of all five,...
  11. Re: Is there any way to check whether an option button has been checked?

    I didn't change the default name, and I don't think I used ActiveX Controls. But just in case, I tried changing the code and now the error I get says "Run-time error '438': Object doesn't support...
  12. Re: Is there any way to check whether an option button has been checked?

    That's interesting that it adds spaces in the option button name, even if the actual name doesn't have spaces. Unfortunately I still get the same error when I include the spaces.
  13. Re: Is there any way to check whether an option button has been checked?

    That gives me a different error. "Run-time error '1004': Unable to get the OptionButtons property of the Worksheet class"
  14. Is there any way to check whether an option button has been checked?

    I'm trying to create a form where, if certain fields are blank, it prevents the user from printing I got most of the code to work, but I can't manage to figure out how to check whether an option...
  15. Re: Trouble pasting VBA code, scrolling down post, typing

    That seems to have done the trick. Thanks!
  16. Replies
    9
    Views
    355

    Re: For loop through array

    Ok I'll give that a try. Thanks!
  17. Replies
    9
    Views
    355

    Re: For loop through array

    Yeah sorry about that, I didn't realize I would be changing the layout of the worksheet when I first posted this question. I'll try to give the simplest example I can. I originally had "part number"...
  18. Re: Trouble pasting VBA code, scrolling down post, typing

    Where do I find that setting? I use Firefox at home, so I'm not too familiar with IE settings.
  19. Replies
    9
    Views
    355

    Re: For loop through array

    I'm noticing an issue with this method. If I have to add or delete any columns or rows, I have to go through and change every reference to the cell number. Is there a way to do that quickly, or would...
  20. Re: If selection in table, start user form in next row

    Actually what I think I need to do is have it so that when any cell in the row directly below the table, and in columns A through D, is selected then the user form will open and the data will be...
  21. Re: Trouble pasting VBA code, scrolling down post, typing

    No worries, I don't expect anyone to sit around all day answering my rookie questions!
    I'm not sure if my IE is the most current version, but it's a work computer so I wouldn't be able to upgrade...
  22. Re: Trouble pasting VBA code, scrolling down post, typing

    Turns out I can only paste using right click, not ctrl+V. Haven't figured out the rest of the problems though.
  23. If selection in table, start user form in next row

    I'm trying to create a user form that opens up any time a cell in a table (or anywhere in a specified range) is selected, that will input data from the user form to the end of the table. I would also...
  24. Replies
    9
    Views
    355

    Re: For loop through array

    Thanks for the suggestion! That does make the code much more concise. To make sure the inputs are valid, I just used an "If" statement that opens a new InputBox if the entry isn't valid.

    Dante,...
  25. Replies
    9
    Views
    355

    For loop through array

    I'm trying to replicate what this code does...


    Sub Workbook_Open()


    'unprotect sheet, start with all cells locked
    ActiveSheet.Unprotect
    ActiveSheet.UsedRange.Locked = True
Results 1 to 25 of 28
Page 1 of 2 1 2