Search:

Type: Posts; User: muleymuel

Page 1 of 3 1 2 3

Search: Search took 0.04 seconds.

  1. Replies
    36
    Views
    2,828

    Re: [excel]

    MY HERO!!!!! Thanks Bryce, may your luck be as long as the mountains.
  2. Replies
    36
    Views
    2,828

    Re: [excel]

    I DO :) thats all i want it to do!
  3. Replies
    36
    Views
    2,828

    Re: [excel]

    ah.. ok... the macro does actually work if I 'Run' it from the Macro list, it is the keyboard shortcut i am using that isnt working. How can i amend the macro to work with the keyboard shortcut,...
  4. Replies
    36
    Views
    2,828

    Re: [excel]

    very frustrating:blush:
  5. Replies
    36
    Views
    2,828

    Re: [excel]

    if i could just record the macro to be at the cell location i choose (active cell) it would be easy as i can record what i would like it to do. The whole point is so that the text box appears in the...
  6. Replies
    36
    Views
    2,828

    Re: [excel]

    the macro wont work at all
  7. Replies
    36
    Views
    2,828

    Re: [excel]

    aaarrrrggghhhh..... i copied the code from post 20 (which definitely works) into a notepad file, then added the code you just suggested, then copied all and replaced the existing macro and now...
  8. Replies
    36
    Views
    2,828

    Re: [excel]

    the code in post 20 is the most current, working code, indeed
  9. Replies
    36
    Views
    2,828

    Re: [excel]

    the above code works, where do i put the


    Selection.ShapeRange.Fill.Solid
    Selection.ShapeRange.Fill.ForeColor.SchemeColor = 43
  10. Replies
    36
    Views
    2,828

    Re: [excel]

    i tried that to no avail bryce. I dont think VBA likes me very much, i always end up with errors that i dont know what they mean or are trying to tell me, then i just mess the code up and there is no...
  11. Replies
    36
    Views
    2,828

    Re: [excel]

    Sub insertphoto()
    '
    ' insertphoto Macro
    ' Macro recorded 01/05/2014 by Amey
    '
    ' Keyboard Shortcut: Ctrl+i

    Dim cel As Range

    Set cel = ActiveCell
  12. Replies
    36
    Views
    2,828

    Re: [excel]

    That does work, but how can i get it to insert when i press Ctrl + i?
  13. Replies
    36
    Views
    2,828

    Re: [excel]

    I am limited to Excel 2003. There is no confusion here other than with code. Unexpected sub ened error when trying to combine my original macro and the active cell commands. As it automatically...
  14. Replies
    36
    Views
    2,828

    Re: [excel]

    Thats fine, not a problem, i just don't want the page to jump around by the focus going elsewhere.
  15. Replies
    36
    Views
    2,828

    Re: [excel]

    The part which re-chooses the active cell after the text box has been inserted. I cant get them both to work at the same time. The macro need not point to any cell at any time, other than the active...
  16. Replies
    36
    Views
    2,828

    Re: [excel]

    i dont understand.. i cant get it to work :(
  17. Replies
    36
    Views
    2,828

    Re: [excel]

    Anywhere I try to put this presents me with error messages. Could you show me how to include that in the original macro please?
  18. Replies
    36
    Views
    2,828

    Re: [excel]

    Ok, so ive edited the text as below which inserts the text box at the active cell perfectly, but then moves the cursor to a different cell. How can i make it stay at the current active cell?

    ...
  19. Replies
    36
    Views
    2,828

    Re: [excel]

    No clue what the second part means, literally like another language :/
    I will try adding in the Active Cell command. Thanks!
  20. Replies
    36
    Views
    2,828

    Re: [excel]

    here is a recording i took which works for inserting the text box at the same location each time. is it possible to have this inserted at the location of the chosen cell?



    ' Keyboard Shortcut:...
  21. Replies
    36
    Views
    2,828

    [RESOLVED] [excel]

    Would anyone be kind enough to write a macro that will insert a text box at the location of a chosen cell? Ideally it would be of 'automatic size', centred both horizontally and vertically,...
  22. Replies
    18
    Views
    2,226

    MsOf03 Re: Code/Macro not updating when file opened

    I don't know :)
    As the code was knocked up with very limited understanding there is probably something in there that is making it stick. Thank you for your assistance Bryce, i will contact you on...
  23. Replies
    18
    Views
    2,226

    MsOf03 Re: Code/Macro not updating when file opened

    Honestly Bryce, i fully appreciate your assistance but its like you're talking another language. I literally don't have a clue what a change event or what step mode is as my knowledge of coding...
  24. Replies
    18
    Views
    2,226

    MsOf03 Re: Code/Macro not updating when file opened

    Bryce, that doesn't seem to be working, in fact it no longer works when you click in the date cell and press enter.
  25. Replies
    18
    Views
    2,226

    MsOf03 Re: Code/Macro not updating when file opened

    102915

    Hopefully it would make more sense to some of you than it does to me.
  26. Replies
    18
    Views
    2,226

    MsOf03 Re: Code/Macro not updating when file opened

    i'm sorry but i just cant get it to work. Could any body please copy my coding above and include the Workbook Open command and paste the results?
  27. Replies
    18
    Views
    2,226

    MsOf03 Re: Code/Macro not updating when file opened

    Not error messages as such, but it wasn't working.
    if my existing code is {MY CODE}, then where do i put the
    Private Sub Workbook_Open()
    End Sub
    ????

    Like this,
    Private Sub Workbook_Open()...
  28. Replies
    18
    Views
    2,226

    MsOf03 Re: Code/Macro not updating when file opened

    i get the message box without any errors, but cant get it to work with the code on the workbook im working on.
  29. Replies
    18
    Views
    2,226

    MsOf03 Re: Code/Macro not updating when file opened

    ive found this but dont know what to do with it. I havent been able to place it anywhere without getting error messages. Where should it go?


    Private Sub Workbook_Open()

    End Sub
  30. Replies
    18
    Views
    2,226

    MsOf03 Re: Code/Macro not updating when file opened

    Thanks Bryce, how would i do that??
  31. Replies
    18
    Views
    2,226

    MsOf03 Code/Macro not updating when file opened

    I am a complete coding novice so please forgive me for my bad explanation but here goes..
    I have a spreadsheet with several functions written into code (largely by help from you guys), however it...
  32. Replies
    2
    Views
    1,122

    Re: Excel 2003 VBA coding problem

    90161

    Certainly. Please find attached. I wouldnt pay much attention to the existing code, it is a patched-together version from various different attempts from forum users. if you would like to...
  33. Replies
    2
    Views
    1,122

    Excel 2003 VBA coding problem

    90159

    Does anyone fancy this? If you have paypal i will gladly reward your efforts
  34. Replies
    31
    Views
    1,335

    Re: Combining code - errors

    :) you are brilliant! thank you so much!!!!

    Could you do me a huuuuge favour? i have quite a few formulas in the spreadsheet i sent you. is it possible to write these into the code too? they all...
  35. Replies
    31
    Views
    1,335

    Re: Combining code - errors

    Thank you very much. i am getting the error message,

    "Compile error.
    Invalid outside procedure"
  36. Replies
    31
    Views
    1,335

    Re: Combining code - errors

    Would you be able to help me with the code please?
  37. Replies
    31
    Views
    1,335

    Re: Combining code - errors

    i hope this makes sense.

    is there a way to preserve the formula, or write it as a macro?
  38. Replies
    31
    Views
    1,335

    Re: Combining code - errors

    in column K i have this formula;

    =IF($B$2:$B$148="","",IF($B$2:$B$148<TODAY(),"ENTER EXAM STATUS",""))

    When the date in column B has been reached the above formula puts "ENTER EXAM STATUS" into...
  39. Replies
    31
    Views
    1,335

    Re: Combining code - errors

    This is not really a problem, i can deal with this as it is, the real... last problem is the problem in post#18. i will try to give you an example......
  40. Replies
    31
    Views
    1,335

    Re: Combining code - errors

    That is what i have done to achieve this, however, it does not have the desired effect when a filter is applied as in Example 2
Results 1 to 40 of 98
Page 1 of 3 1 2 3



Click Here to Expand Forum to Full Width