Recent content by joem28a

Hi PalmTest, Very interesting tool indeed; thank you for that.

Hi Jimbopalmer / Cyberspace, Many thanks for your suggestions. I actually saw bginfo one day after I posted my request; very useful information; especially from a support persepective. Take care. Regards, Joem28a

Hi folks, I am looking for some code to simply display the TCP/IP Settings via XP desktop; nothing fancy, just a simple display of the IP Address settings. Once displayed, the User can just click on an "Exit" button. Hope someone can assist. Many thanks. Regards, Joe28a

Hi folks, I am looking for a batch file that can disable / enable Proxy Settings in IE 6.0 via registry. At the mement there are quite a few mouse clicks to do this manually. Appreciate your assistance. Many thanks. Regards, Joe28a

Hi Glenn & Tony, Well done; thank you very much for that. All worked beautifully !!!. Greatly appreciated; take care. Regards, Joe.

Hello, Thank you for your prompt reply. Almost there ..... your code worked great, in that it no longer displayed the "#N/A"; however, when selecting a valid entry it display "#N/A" every other time instead of the matched value in Sheet 2. Many thanks. Regards, Joe

Hello, I have been using the INDEX/MATCH function successfully in Excel. Unfortunately, when a cell has no value, it presents a "#N/A"; which doesn't look too good. I am using the following syntax: =INDEX(Sheet2!A2:E453,MATCH(A6,Sheet2!A2:A453,0),2) Can someone plase advise how to remove or...

Hi there Geoff, I tried your code in several different configurations; nothing happened to the other spreadsheet Sub Button_ARL_Click() ToggleActiveCell "ARL", White, CellBold, FontSize8, Brown With Workbook("Sick_2").Sheet("Government...

Hi folks, Could somebody please assist me here. I wish to be able to duplicate data in another spreadsheet in the absolute cell. For example, my current spreadsheet contains a Macro, in that when you click on "ARL"; it changes the active cell to read "ARL" with all the...

Geoff, No, the worksheet is actually called "SIG". Also, for clarification, do I place your code in the other worksheets of just the master or destination worksheet?. Thanks. Regards, Joe.

Hi there Geoff, I tried the new code; no success. The cells in Sheet 4 are just not updating !!!; the text is visible but not the background colour????. Would it be possible to send the spreadsheet to you?; I will remember you in my Will if you could solve this !!!!. Many thanks. Regards, Joe.

Hi there Geoff, I didn't think I explained myself properly. Here is what I am doing, I have 1 spreadhsheet with 4 worksheets called Team 1, Team 2, Team 3 & Team 4; the 4th worksheet is the overall or statistics worksheet. Annual Leave, Maternity Leave, Sick Leave and so on is recorded on the...

Geoff, I managed to figure out how to change the Font and Font Colour, etc. I have just applied the code in my Spreadsheet and have one little issue. What my spreadsheet does is when when you enter a value or text in one cell of a worksheet, I have a duplicate copy of what was entered on...

Hi there Geoff, Fantastic !!!; just to go in a little deeper; what is the syntax for Font Type; Text Justification and other colours?. How did you come across the "Colorindex number" as below?. My VBE Help is not worling for some reason. Many thanks. oCell.Interior.Colorindex = 5...

Geoff, I honestly have; but they didn't seem to work ... I do not know why. I have copied and pasted the code, to no avail. I am obviously not doing something right; I really want to solve this. Thank you. Regards, Joe.