Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by sten28

  1. sten28

    Outlook 2003: Automatic colouring for calendar items

    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...
  2. sten28

    Distributing a custom icon through WinZip to XP machines

    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.
  3. sten28

    Distributing a custom icon through WinZip to XP machines

    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...
  4. sten28

    Saving multi selected list box answers to a table?

    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...
  5. sten28

    Count of seperate objects

    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...
  6. sten28

    Create an external outlook template?

    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?
  7. sten28

    Create an external outlook template?

    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.
  8. sten28

    Create an external outlook template?

    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...
  9. sten28

    Adding a prefix to cell entries?

    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
  10. sten28

    Validation rule for phone number formatting

    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
  11. sten28

    Validation rule for phone number formatting

    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...
  12. sten28

    Validation rule for phone number formatting

    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
  13. sten28

    Validation rule for phone number formatting

    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?
  14. sten28

    Validation rule for phone number formatting

    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...
  15. sten28

    Excel: Automatic Conditioning of Text Cell Entries

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

Part and Inventory Search

Back
Top