Search:
Type: Posts; User: muleymuel
Search:
Search took 0.04 seconds.
-
MY HERO!!!!! Thanks Bryce, may your luck be as long as the mountains.
-
I DO :) thats all i want it to do!
-
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,...
-
-
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...
-
the macro wont work at all
-
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...
-
the code in post 20 is the most current, working code, indeed
-
the above code works, where do i put the
Selection.ShapeRange.Fill.Solid
Selection.ShapeRange.Fill.ForeColor.SchemeColor = 43
-
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...
-
Sub insertphoto()
'
' insertphoto Macro
' Macro recorded 01/05/2014 by Amey
'
' Keyboard Shortcut: Ctrl+i
Dim cel As Range
Set cel = ActiveCell
-
That does work, but how can i get it to insert when i press Ctrl + i?
-
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...
-
Thats fine, not a problem, i just don't want the page to jump around by the focus going elsewhere.
-
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...
-
i dont understand.. i cant get it to work :(
-
Anywhere I try to put this presents me with error messages. Could you show me how to include that in the original macro please?
-
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?
...
-
No clue what the second part means, literally like another language :/
I will try adding in the Active Cell command. Thanks!
-
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:...
-
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,...
-
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...
-
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...
-
Bryce, that doesn't seem to be working, in fact it no longer works when you click in the date cell and press enter.
-
102915
Hopefully it would make more sense to some of you than it does to me.
-
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?
-
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()...
-
i get the message box without any errors, but cant get it to work with the code on the workbook im working on.
-
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
-
Thanks Bryce, how would i do that??
-
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...
-
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...
-
90159
Does anyone fancy this? If you have paypal i will gladly reward your efforts
-
:) 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...
-
Thank you very much. i am getting the error message,
"Compile error.
Invalid outside procedure"
-
Would you be able to help me with the code please?
-
i hope this makes sense.
is there a way to preserve the formula, or write it as a macro?
-
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...
-
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......
-
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
|
Click Here to Expand Forum to Full Width
|