Recent content by have-a-go-green

Hi Hui, Thanks for the response. I didnt want to complicate things by attaching the project im working on because there are a range of things that im trying to work out and would have ended up just picking your brain with all of them at once. Ive sorted this one now. It turns out that i had my...

any thoughts guys

Hi is there a way i can set up a data base of advisors linked to their managers/teams, so that when the envion username macro picks up the username/advisor id, it will automatically pick up which manager they belong to. to elaborate a little more, i have a tracker set up, that logs various...

Hi Narayan You desrve a medal for the amount of effort you put in to your responses :) I do have to apologise though, as i have a very bad habbit, of hitting a brick wall, with a problem and posting my query on here, but, then end up resolving it myself...

Please can someone, tell me what is wrong with my formula. my aim, is to add a RED, AMBER, GREEN, column to a range of advisor stats. =If(C2<G$1,"Target","",IF(C2<F$1,"Stretch","",IF (C2>G$1,"Loser",))

woohoo!! sussed it. excel is freaking awesome

Hi I recently posted a question around this topic, but i ended up working it out myself, due to the answer being pretty obviously VLOOKUP. Ive now got my search engine set up and working really well with a webBrowser control and navigate button macro. Im now stuck at the final hurdel of being...

Ok, so, vlookup was the "obvious" winner here.. My bad.

Hi I'm trying to create a user friendly sheet, that, amongst other things in other sheets, will have one shett with the purpose of providing a WebBrowser that I have set up to, browse from the same cell that returns the results of a data validation list of URL's. The problem for the user...

Hmmm, something to ponder on, me thinks.. I'll get back to you. Thanks

Any thought, anyone?

-EDIT- Ive found sound beautiful code that sorts out my "allways on top" option, that even enables the user to switch the option off. (Option Explicit Declare Function SetWindowPos Lib "user32" _ (ByVal hwnd As Long, ByVal hWndInsertAfter As Long, _ ByVal X As Long, ByVal Y As Long...

Hi, well, im open to other suggestions, on how to achieve my goal. Is there a different way this could be done?, would javascript be the answer?. My other thought, was to set my worksheet, to always be ontop of al other open pages... although, this, i feel, would be somewhat of an anticlimax...

Hi Narayan, thanks for your time so far on this. I think my inexperience in vba is now showing, as, im unsure what you mean. are you saying that this cant be done?

Hi, I know nothing about javascript :( hopefully the code below will show up on this post and show you what i have so far. The softphone that is being used, already controls all the stats in the background, but, because there are thousands of advisors that have to be monitored, we dont...