Page 1 of 2 12 LastLast
Results 1 to 15 of 20
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Spreadsheet questions (2003)

    I have a spreadsheet (not mine) that is setup so that in column A there is a list of numbers - I don't think it is actually in A but it is setup to look like it is. It has a scroll bar to the right of the list of numbers. When you click on a number, it shows graphs associated with that number. As it is now, you have to click on a number and then print the graphs. I would like to print all the graphs instead of just printing one at a time. Is there a way to do this? Any help would be greatly appreciated.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Spreadsheet questions (2003)

    You could write a macro that loops through the values, and prints the charts for each of them.
    If you would like help with that, we'd have to see (a copy of) the workbook.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spreadsheet questions (2003)

    I don't think I can send the spreadsheet because it has confidential informtion.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Spreadsheet questions (2003)

    I understand that, but without knowing how the data in the worksheet are laid out it's impossible to say what the macro should look like...

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spreadsheet questions (2003)

    I did take out all the data - would the bare bones of the spreadsheet be enough?

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Spreadsheet questions (2003)

    You can try - or put in just a few dummy data.

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Spreadsheet questions (2003)

    But you forgot to attach it...

    Steve

  8. #8
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spreadsheet questions (2003)

    I can't get it down to 100 k. I zipped it and it is 210 K.

  9. #9
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spreadsheet questions (2003)

    I have stripped it down to as much as I can and zipped it but it is still 200 k. Is there anything else I can do?

  10. #10
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spreadsheet questions (2003)

    When I viewed toolbars and selected the Control toolbox and clicked on the list box there is this =embed("forms.Listbox.1",""). I am just grasping at straws.

  11. #11
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spreadsheet questions (2003)

    I found the following code. Could this work? I need to print though - not sure what code to do this.

    Sub LoopListBoxes()
    Dim OleObj As OLEObject

    For Each OleObj In ActiveSheet.OLEObjects
    If OleObj.progID = "Forms. ListBox.1" Then
    MsgBox OleObj.Object.ListCount
    End If
    Next OleObj
    End Sub

  12. #12
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Spreadsheet questions (2003)

    Try to delete things not required for the the example. We don't need everything the workbook can do, only the parts relevant to the question.

    Steve

  13. #13
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Spreadsheet questions (2003)

    If you turn on design mode on the Control Toolbox (the first button on this toolbar) and click on the list in column A, you should select the list box. (If not, it's another type of list box).
    Which name do you see in the Name box on the left hand side of the formula bar?

  14. #14
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Spreadsheet questions (2003)

    I don't see why it is relevant since you want to print charts and the code has nothing to do with charts or chartobjects...

    Steve

  15. #15
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spreadsheet questions (2003)

    Listbox1 is the name.

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •