Search:

Type: Posts; User: strobinson1

Page 1 of 5 1 2 3 4

Search: Search took 0.03 seconds.

  1. Re: Excel Form, List box. Multi selects on first click

    Ok, so I've fixed it. By fudging it. It seems to have something to do with the list box being inside a frame. When I was clicking on the list box it seemed loop through the _change code twice,...
  2. Re: Excel Form, List box. Multi selects on first click

    Only code under _Change and _DblClick, neither of which are triggered when you click on it. Code beneath both only changes the caption on a label...
  3. Re: How to draw a chart in excel with bars similar to MS Project?

    See the attached image. If you arrange your data as shown and use a scatter chart you should be able to draw something similar. With the data, note that you have to plot each point on the line to...
  4. [RESOLVED] Excel Form, List box. Multi selects on first click

    Hi,

    I've a bit of an unusual bug that is a bit a nuisance. Hopefully this will make sense:

    I've got a list box in a form. Alongside it I have a number of other controls that allow me to...
  5. Replies
    5
    Views
    3,607

    Re: VBA Excel and IE

    Got it to work now. Very minor changes. Still needed the visible tweak in there to make the whole window appear. Job done. Cheers!





    Dim w As InternetExplorer

    For Each w...
  6. Replies
    5
    Views
    3,607

    Re: VBA Excel and IE

    I'm working with Excel 2003 and IE 8. Might be behaving differently if you are using a later Excel/IE ?

    Could there be a better way for me find the open IE object and navigate through the tabs? ...
  7. Replies
    5
    Views
    3,607

    VBA Excel and IE

    :check:Ok, should be a quick one. I'm struggling to do something that should be obvious. Must be a lack of cafeine or something. Anyway, any help greatly appreciated!

    Below is some simple code...
  8. Replies
    3
    Views
    13,390

    Re: Open Adobe Reader from Excel

    Hi Rocker,

    I work in a terminal server environment which means I don't have access to the C:\ so I couldn't access the exe direct. I found the solution now:

    Need to add the Adobe Acrobat 10...
  9. Re: Why is my Excel file corrupt?

    I've had this happen to me before on workbooks that have very long formulas and many of them, across various sheets. I think it sometimes gets screwed up trying to recalculate them in the right...
  10. Re: Cant copy ranges with variables in Excel VBA

    yeah that's true. In fact should probably just do this and drop the "select" parts that are not needed altogether



    ActiveSheet.Rows(lFilaIntercambio - 1).Copy...
  11. Re: Cant copy ranges with variables in Excel VBA

    try this:



    ActiveSheet.Rows(lFilaIntercambio - 1).Select
    Selection.Copy
    ActiveSheet.Rows(lFilaIntercambio).Select
    ActiveSheet.Rows(lFilaIntercambio).PasteSpecial xlAll
  12. Replies
    3
    Views
    13,390

    [RESOLVED] Open Adobe Reader from Excel

    I'm sure there is something very simple I'm missing. Can anyone see it?

    Trying to open Adobe reader from Excel. Both "set..." statements produce the error message "ActiveX component can't create...
  13. Replies
    15
    Views
    23,214

    Re: Excel. Button shrinks!

    Yes. I found I was getting this problem when moving to a different computer with a different resolution.

    I'd open my remote desktop on one computer and open my Excel sheet. Then, without...
  14. Re: [RESOLVED] Excel file increased unreasonably

    yes, that would work. Although my actual sheet has lots of controls on it and other stuff that I didn't really want to have to copy over.

    And, plus that sheet is REALLY annoying me that I can't...
  15. Re: [RESOLVED] Excel file increased unreasonably

    Ok, so I didn't think I'd be coming back to this thread....

    think of it as a challenge....

    The sheet is completely empty. I have even tried the ExcelDiet Macro (it is in the sheet already). ...
  16. Re: [RESOLVED] Adding a custom right-click option

    lol.

    There's also two other commandbars I had to add for when you have a data query behind the sheet. called "Query" and "Query Layout".
  17. Re: Adding a custom right-click option

    yeah, found it !

    Problem was it was called "Cell" aswell !

    so had to do this:


    Set cBut2 = Application.CommandBars.FindControl(ID:=1588).Parent.Controls.Add(temporary:=True)
  18. [RESOLVED] Adding a custom right-click option

    Hi,

    I have written the code below to put an additional option on the right-click menu of Excel.

    However, if the spreadsheet is in the "Page Break" preview, it doesn't appear.

    Any ideas how...
  19. Re: Getting a worksheets VBA name?

    bingo!

    wow, that was a lot simpler than I thought it would be !

    CHEERS
  20. Re: Getting a worksheets VBA name?

    ah! no, not quite. see the attached image.

    If I know the sheet name is "Raw Data", can I find out that is referenced as Sheet13 ?
  21. Re: Getting a worksheets VBA name?

    Doesn't that just give me the sheet filename and path?
  22. Re: Getting a worksheets VBA name?

    Hi Steve,

    Thanks, however I am trying to do something more complex than that. I have an image on the sheet that I want to assign to a macro.

    Using the above, if I had a macro on the "Raw Data"...
  23. [RESOLVED] Getting a worksheets VBA name?

    Hi,

    Is there any code in VBA that I can use to find out the VBA name of a worksheet?

    As in, if you look at the VBA window, in the Project Tree on the left hand side, you can see all of your...
  24. Replies
    3
    Views
    1,708

    Re: [RESOLVED] InStrRev in Excel

    "InstrRev(Str1, Str2) checks backward from right-to-left.
    That does not mean counting from right-to-left."

    aah, now it makes sense ! CHeers ! :)
  25. Replies
    3
    Views
    1,708

    [RESOLVED] InStrRev in Excel

    Am I missing something...

    Code below...

    Both give the answer 5 ! Surely the first one should be telling me 1 ?


    Sub test()

    Debug.Print InStrRev("simon", "n")
  26. Re: worksheet_Change. Test for arrow key or mouse click

    CHeers Koolsid!

    Worked a treat.

    SR
  27. [RESOLVED] worksheet_Change. Test for arrow key or mouse click

    Hi,

    With the worksheet_Change procedure... is it possible to determine if a cell was selected using the arrow keys on the keyboard or the mouse?

    ie I only want it to run the macro if it was...
  28. Replies
    15
    Views
    23,214

    Re: Excel. Button shrinks!

    2003. I work through a remote connection to a server that all my company works off so I don't know if that has anything to do with it or not compared to a standalone version
  29. Replies
    15
    Views
    23,214

    Excel. Button shrinks!

    Has anyone experienced their buttons on an excel sheet shrinking when you click on them ?

    It happens to me sometimes. Or the text inside the control (eg a combobox) gets bigger each time I use...
  30. Re: [RESOLVED] Remove "Microsoft Excel" from the window name?

    Just found a flaw in this method...

    Everytime you then use screenupdating = true, or change worksheet even, it resets !
  31. Re: Remove "Microsoft Excel" from the window name?

    Thanks guys, that works a treat. I am a big novice when it comes to API's. Look like a huge untapped resource I should look into !
  32. [RESOLVED] Remove "Microsoft Excel" from the window name?

    Is it possible to change/remove the Microsoft Excel text from the top of the Excel window...where it appears along side the workbook name ?


    If so.... can you show me how?!??
  33. Re: FormulaArray result into Variable?

    yeah ok. didn't think it was going to be possible ! Cheers for the responses !
  34. [CLOSED] FormulaArray result into Variable?

    Hi,

    Is it possible, instead of doing:

    range("A10").FormulaArrary = "=product(A1:A9+1)-1"

    and the result being put into the cell A10...

    I want to put the result directly into a variable...
  35. Re: vba on a combobox embedded on a sheet

    yep.

    that's what I managed to do !

    Cheers :)

    Simon
  36. [RESOLVED] vba on a combobox embedded on a sheet

    Hi,

    I want to write some VBA code to Loop through all the entries in a combobox that is embedded in a sheet, and run a different sub each time.


    ie

    for i = 0 to 10...
  37. Replies
    4
    Views
    385

    Re: Number Problem - Any inspiration?

    I have written a macro of 20 loops within loops. Tested in on a number that I knew would definitely be a combination of the other numbers and it does find it....eventually.

    Then ran it on the...
  38. Replies
    4
    Views
    385

    Re: Number Problem - Any inspiration?

    Sure... see the attached...

    the numbers on the left are the originals. the ones on the right are the group totals. I need to work out what combination of numbers from the left will split into...
  39. Replies
    4
    Views
    385

    Number Problem - Any inspiration?

    Hi,

    Any ideas on how to find out the answer to this easily, greatly appreciated... !


    I have a list of 20 different numbers. Last week I split them into two groups (not necessarily in half)....
  40. Re: Find the End row of a selection - EXCEL VBA

    ok, so that should have been obvious. Clearly a Friday!

    Cheers,
Results 1 to 40 of 163
Page 1 of 5 1 2 3 4



Click Here to Expand Forum to Full Width