Replies

ok, so i tried slotting the DoEvents instruction in the Refresh_Trigger() Sub, just after the “If CountdownActive Then” line

not sure i grasp this function fully, anyway, it doesn’t do what i was looking for, whilst it does settle the cursor down, and stop it from flickering, and also slow the focusing issue, i still lose the comments after a very brief period, and they don’t come back on anymore (blink on then off then on effect)

2010 themes,

http://www.mediafire.com/download/2x52ud6n52w347n/Document_Themes_14.zip

also, you can download themes from the link below for free, and even if they say for powerpoint, you can use them in excel i believe, just copy them to your “Document Themes xx” folder

https://templates.office.com/en-us/Themes

in addition, this might be handy if your looking to see what’s installed with which version

http://www.indezine.com/products/powerpoint/learn/themes/which-themes-are-installed.html

ok, i got errors all over the place on that file, first thing were 2 functions not 64bit office compatible, fixed those then got type mismatch, so i missed something in there relating to longptr i guess, but, that uses times again, so i don’t think i want to go down that route, i can live with the standard cross cursor, i was just hoping (naively) that if you swapped out the base cursor (default one) then the replacement would behave the same and not over-ride subsequent instructions to change

some you win some you lose !…. my spin button now works as i want, so i’ll take that as my win !

found something else that goes pair shaped when you insert rows…. the objects associated with them, lol, all my tick box names went pear shaped, and their linked cells were a mess, so, no more inserting rows !!

Anyway, made quite a few changes, so thought best to upload a new copy of the file, in case anyone looks to fix things i’ve already tweaked, quite a number of things now changed, and the worksheet change events are getting harder to keep track of and avoid duplication/re-triggering, i’ve also tightened down the calculations so less round up vs down conversion errors, and i’ve also got creative with some of the cell formatting, switching it around with conditional formatting, almost beginning to wish i’d left the share prices in pence !!

I did play with selective locking of the sheet, adding a parameter to the .protect call, allowing the vba code permission to alter locked cells, but not the user interface, but it failed spectacularly, so i went back to the other method of unlocking/locking each time

Highlighting is still broken

hahahahahahahaha

i never saw that typo, but yes, that’d be the workbook lol (new one of those about to be uploaded as i’ve been playing a lot with it, so thought would be good to update the one i had there)

will have a look at your file, as it’s always good to learn/see new things in action

EDIT:
and yes, i’ve crossed swords so to speak with cursors in the past, with mixed results

excellent idea to use a blank macro, i will go incorporate that

thank you

Morning,

Laptop, 17″ screen Res 1920×1080

Single monitor 99% of the time, occasionally hook to external, but not often.

I do however use FileBox eXtender (http://www.hyperionics.com/files/) so i can pin, or roll windows up. Although it does have a bit of a bug, if you display folder in list, sort and group by date created, then occasionally it crashes explorer when your scrolling left or right, or resizing the window width wise !…. so i might swap to display fusion pro, which does mostely the same functions (albeit intended for dual monitors) minus the handy favourites menu which i use

INDIRECT huh, hmmmmm, i’ll have to research that

ok, no problem, the highlighting unhook has me beat, it’s the only bit i can’t work out properly, i’ve added a couple of things, and a few rows to the worksheet then sweared heavily at it as it screwed up the conditional formatting – adding new entries for the copied rows, not expanding the given “applies to” entries/ranges, probably something to do with the cell designation default in conditional formatting of $x$x which has always been a pain in the ass at times

anyway, all is working well, minus the highlighting, and the fact yahoo finance data can be pretty inaccurate at times !

will await your latest to see if you’ve cracked it

A workbook can have its own modified colour palette. To reset to the default choose Tools|Options|Color tab, click Reset then OK

here’s a couple of links relating to colour palette issues, and also an add-in that’s supposed to solve the problem of workbooks over-righting the default

http://www.mrexcel.com/forum/excel-questions/430667-excel-2003-color-palette-changes.html

http://www.techsupportforum.com/forums/f57/excel-highlight-color-changes-between-sessions-283619.html

http://www.4shared.com/file/65936963/40eb1d22/ZVI_TrueColors.html

hopefully, one of those will help shed some light on your problem

When you use vba to put a formula into a cell ‘one-at-a-time’ (as your previous method), the formula is ‘calculated’ as it is placed into each cell, regardless of whether calc mode is manual or not. So that is why it worked previously.

ah now that i did not know, could explain a couple of things ! – i have since altered that formula, to accommodate something new in the way i wanted the sheet to behave, but i have gone back to my original code for that section, cause i had issues elsewhere, which kinda fell into the “dunno why it’s doing that” category, so i went back lol

I’ll have another look at your internet check code, that is one thing i’m not massively happy with i have to admit, because when there is a connection available, it can still hang for a while if i’m connected via my phone and the signal is poor, so i might look to tighten it up, and cancel out earlier, but will look see what you’ve tweaked

Still haven’t touched your module [System_Event_Hook_Code]

i’ve been playing around with that a little, gone back to calling the function from an intermediary sub routine, like it was in the original code i got it from, and it shouldn’t make any difference, but, sometimes it seems to, like earlier, i had it running ok, if i switched out to notepad, and then closed, but if i went to the vba editor, it failed, but, that was not a consistant result – i’m about at the end of my abilities with it, i might strip it back to 32 bit only, and put it onto my spare laptop which has 32 bit office on it, and see what happens.

yup, the comments should be modal all the time, but that’s more an excel thing than anything else, just the way it is

Reset the Formula inserting code to avoid the non-updating issue, so many different triggering events it’s difficult to avoid getting into a nasty loop, or constantly calculating the sheet, for now this seems ok, so i’ll stick with that method, i did however incorporate some of your other stuff, thanks

Changed a few things to make operation a little more user friendly, and fixed a bug or 2, so here’s v8

yeah, windows is set to Pounds as currency, however, this workbook is hard coded to Pound symbols, because the data i’m importing should be in UK currency, although, there is one point it goes horribly wrong, if the share price us for a US share and it’s in dollars!

i think i got to the answer at about the same time you did there one question though, you went for 3x “#” infront of the first “,” …..wouldn’t that display 2 leading zeros on a value ?

i got it, it wasn’t so hard when i realised i needed to format it before putting it into the comment

changed the line building the text and adding the comment to this

Code:

cell.AddComment Text:="Current Value: " & vbLf & Format(cell.Value + cell.Offset(0, 1).Value, " £ #,##0.00")

and voila, perfect, as for the minus symbol, i was getting confused, it would not show that, because the value whilst less than the cost, would not be a negative value :rolleyes:

latest version, incorporating those changes, and some others (font colours and new comment on the profit/loss cells)

EDIT:
something in your changes that i’ve implemented has killed the comment updating, as i suspected messing with the change event trigger i think, or my formula coding, damit!
EDIT2:
yup, copying and pasting the formulas from the H1 cell down, was the problem, the following code that then read the value, was not seeing it, have to trigger a sheet calculate event or thec omments fail to update, or, go back to what i had that was working :rolleyes:

ok ,i’ve stepped through your other changes, and integrated them, i was wondering why you changed the build url section at first – i was working on the idea of fixing the end point by named cell, and then it doesn’t matter if rows are added or not later, but i forgot named ranges expand automatically like that

as for putting the formula in the cell, and copying from there, yeah that’s one way, i usually do have stuff orphaned all over the worksheet like that, and it’s caused me headaches in the past as things have changed over time, hence why the one’s i have used, are off to the right and named