Search results for query: *

I know that you can set automatic formatting for calendar items on Outlook 2003 to colour items as they are created. However, an excerpt from Microsoft's help file says: "If you open another person’s calendar or a calendar stored in a public folder, you will see the colors that were assigned...

I came up with a solution I created a self-extracting WinZip that installed the icon to a subtle location in C: and made the url's icon data refer to that.

I have created a self-extracting WinZip file that contains a URL with a custom icon instead of your typical default web browser icon. When I distribute this WinZip to others and they extract the URL, the icon does not appear. This is because the icon's location is still refering to my local...

I’m basically trying to create a form that displays a list box that displays information from a separate lookup table that will be saved into my main table of records. I want to be able to select more than one answer in this lookup table and have the form save it into the main table. To give an...

I'm having some trouble creating a formula that will Count something as a sub-total. Here's the scenario: I have a list of people; Gender is a field. I want to do a count of all people, then do a separate Count of how many Males exist and how many Females exist. I started by trying a formula...

Ok, I got it working - it seems that I had to create a new email message for it to recognise the changes. New problem - when I open the template, my Signature block is placed above the content in the message. Is there any way to prevent this?

On top of this I've been referring to http://office.microsoft.com/en-us/outlook/HA010865001033.aspx?pid=CL100626971033 It's getting me on the right track, however, "Outlook Template" does not appear as a file type.

I'm trying to create an Outlook draft template that is stored offline, like a word .dot file Basically it'll contain an email address, title and content of the email automatically so the user can fill in all the necessary details and submit. I can't do this via HTML because it'll be an...

Hi guys, I was wondering if Excel is able to check a cell to see if "www." is included at the start of the cell and insert "www." into the cell after data has been entered if it hasn't yet been entered? Thanks! Sten

Well, not only am I convinced Excel has made it way too hard to format this, but my boss agrees to. So thankfully this isn't something I need to implement now. Thanks for everyone who assisted! Cheers, Sten

Still having a few more issues: The code provided works for 1 cell, but I'm trying to have it work over a range of cells. Below is what I'm trying to achieve: =AND(LEN(I4:I65536)=12,MID(I4:I65536,3,1)=" ",MID(I4:I65536,8,1)=" ",ISNUMBER(SUBSTITUTE(I4:I65536," ","")+0)) The only difference is...

Hi Yogia, That works a treat! Thank you very much! Is it possible to enter a 10 digit number (i.e 0012341234) and have Excel correct the formatting and insert the spaces (so it would become 00 1234 1234) before checking for the validation? Kind Regards, Sten

Hey Skip, The cell formatting isn't the issue (besides, there's no support for Australian phone number cell formats!) - I want to ensure that end users cannot enter anything but 10 digits and that it also enters the appropriate spaces. Is it possible that it's another problem that only VB can fix?

Hi guys, I'm trying to create a validation rule that ensures that phone numbers entered under a field appear in the following format style: 0# #### #### I can achieve this through the Custom option in Format Cells (the 0 at the front is there because Excel removes it because it thinks it's...

Brilliant! I was getting scared for a moment when I noticed VB only supported UCase and LCase! Thanks heaps! Sten :-)

Thanks a ton! One last question though - is it possible to format the text as Title Case (Mr Joe Bloggs) instead of UPPERCASE (MR JOE BLOGGS)? Cheers, Sten

No worries, I'll run it past the VB crew, cheers

It's been suggested I ask here to see if anyone can help: To be brief, I'm using Microsoft Excel 2003 and am trying to achieve the following: * a user enters text into a cell * Excel will automatically format the cell into Title Case Simple what I want to achieve, but it's proving harder...

Is there any way this can be done without VB? I thought it would've been a conditional format.

Hi there, To be brief, I'm using Microsoft Excel 2003 and am trying to achieve the following: * a user enters text into a cell * Excel will automatically format the cell into Title Case Simple what I want to achieve, but it's proving harder than I thought it'd be! Any advice?