Recent content by Nicos67

Thanks JPaules Nico

Hi Mnat tahnsk for all your replies: Glenn uk : I ahve to work on RAG scoring (1, = Red Amber = 2 Green = 3) Each RAG on Parameters so Red is over a certain mumber e.g if over 10 or over = RED If between 3 - 9 = Amber If inder 3 = Red Thing is I have about 50 mertisc to rage each with their...

Hi All, How do I write a COUNTIF formula to produce the following results: I have active linked cells that show totals I want the countif in another location to show that if: the cells contents are over a certain number to show 1 the cells contents are under a cettain number to show 3 the...

Hi ALL, I have set up using Data Validation Function wirthin Excel using a list of 25 items taken from a list within same Tab of workbook. I want the List on selection and click to take the user to a certain 25 locations (within same sheet) locations have charts I want uswer to basically...

Many Thanks Geoff

Thanks Goff very kind have opened control tool boc have 5 tabs Size, Protection, Properties, Web and Control Cant find font size any where within these 5 is there an alternative? as control only shows input range Cell link Drop down lines 3d shading I'm I missing something Many thanks...

Hi All, How do I change the size of font within Combo and List boxes within Excel Forms Many thanks in advance Nico

I have designed a custom form in MS Outlook - Task - Would ilke to use this custom form as a template for arnother 50 tasks Have tried to publish facility but does not save after I close and re-open each respective task ,in which I have attempted to save it. Please Help Nico

Hello All please advise I want to have an auto-shape circle in Excel under the Drawing function - to show RED if a cell has a No input and also to show Green when the smae cell has a YES input I can do this with Conditional Formating within a cell but would like to perform the above within an...

Thanks - would you know how to have the calendar pop on the mouse rollover

Hello all, How do I build the active x calader control within combo box as pop up , that allows a user to populate the combo box with a user selected date from calendar?? Thanks all Nico

Hi All, How do I convery clients years of age eg (41.3) into client Date of Birt in a query Thanks Nicos

Hello all, Need help to change UK postcodes which are set out as follow: WA28WA CH451NT That is 6 or 7 in a string I need them to look like this: WA2 8WA CH45 1NT That is with a space after the 3rd figure if 6 figures in string , or after 4th figure if 7 figures in string Please advise

I have set up a datafield on a subform to collect Treatment date(s): When User attempts to complete date ie :01/01/2004 ETC.. A pop up appears with following message: You can't assign a value to an object: Object may be a control on a read only form: Object may be on a form that is in design...

Thanks Lupins & JonoB Much appreciated Nicos